VLOOKUP problems

[Gee...]

In a workbook I have a spreadsheet that is supposed to
look up and fill in from another spreadsheet. I have a
drop-down with the named array from column B in the LIST
MAY 03 spreadsheet...isn't this supposed to work:
C2 is what's to match, I've listed the spreadsheet name
and the range that C2 will be found in, and to go over 3
columns.

=VLOOKUP(C2,'LIST MAY 03'!B1:B1724,3)

What am I doing wrong?
Thank you.

 

[Juan Sanchez]

Gee

It works for me, the only thing I typed different on the
formula is the last term for vlookup which is boolean and
means do you want an aproximate or exact match? (false for
exact match, true for approximate)

=VLOOKUP(C7,'List May 03'!C4:E10,3,FALSE)

Cheers
Juan

 

[Ken]

Looks like your range is wrong. You show column B only
(B1:B1724). You are telling Excel to use the third column
in "LIST MAY 03", but you have only one column (B) in your
array. If the column you want to have returned is column
D, you need to change your array reference to B11724.

 

[Tom Ogilvy]

You corrected the source of the problem in your example without pointing it
out. The OP had a single column lookup range. You have made yours 3 columns
wide so it doesn't produce the error.

=VLOOKUP(C2,'LIST MAY 03'!B11724,3)

would be the basic fix.

then if there is a preference for an exact match, adding a fourth argument
of false would do that

=VLOOKUP(C2,'LIST MAY 03'!B11724,3,False)

 

[Juan Sanchez]

Thanks Tom, I didn't spot that out until a read Ken's
reply... I'm trying to do my best, I'm sure that with your
help best will be even better...!

Juan