Which Function To Use

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am running Excel 2003. Im trying to accomplish a lookup.

On sheet 1, in column A, I have values such as: A, B, C, D. These values
repeat themselves. A small example:

a date place
b date place
b date place
a date place
c date place

On my second sheet, we'll call it the "a" sheet, I want this sheet to
basically list only the cells that had "a" in column A from sheet 1. So I
would want to see on this sheet (using above example)

a date place
a date place

I've tried using VLOOKUP, but am getting strange results. I think it's
because the values repeat themelves ..but Im not sure.

Any help is greatly appreciated.
 
thanks..but that's not going to work for me.

I really need a function that can return the results I need on separate
sheets.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

REPOST: Which Function to Use 3
Need VLOOKUP to Work Two Ways 0
Excel How to run multiple Private Sub Worksheet_Change(ByVal Target As Range) 0
Update cell value based on name and specific date 1
SumProduct Between Dates 1
Sumproduct Question Working With Start and End Date Range 1
Reserved dates 3
First column of range in VLOOKUP contains formula 2

Back
Top