I copied the lookup values to column A on sheet1. I copied the cells I want
to see if there is a match in to column B on sheet1. I copied this formula
to column C where I want to see if there is a match or not.
Am I supposed to have a value in column D or can I only have 3 columns? to
make it work or should I just use a lookup instead of a vlookup? It seems
impossibly hard to do the vlookup directly on the sheets themselves so I
copied the columns to a new sheet. I still can't get it to work. I think
the vlookup is not very intuitive. Unfortunately I have all these sheets I
have to find matching values. I would like to understand it.
thanks,
"Gord Dibben" wrote:

Where is your "lookup" value?

What is your "Lookup Table"?

Which is your "column index" number?

Show us your formula please.


Gord Dibben MS Excel MVP

On Mon, 30 Jul 2007 10:42:00 -0700, Janis
wrote:

What am I not gettin?

I have a list in column A. I want to find an exact match on column B if
there is one.

I have the vlookup formula in column C. In column C all I get is #n/a.
There are some matches so something is wrong with my formula.

Please help.

tia,