Simple VLOOKUP problem

C

chris

I am a first time user of the VLOOKUP function so am sure I have missed
something basic but can't see what it is. The formula is returning #N/A
despite the value being in the table array. The formula I have is:

=VLOOKUP(D3,$I$3:$J:$361,2,TRUE)

I am basically trying to lookup a name in D3 and match it with the
corresponding name in the table I3:J361 and then return the value in column 2
of the table. If I do =D3=I1340 then TRUE is returned so the formatting
appears to be the same.

Anyone have any ideas whatsoever???
 
B

Biff

=VLOOKUP(D3,$I$3:$J:$361,2,TRUE)

Change to:

=VLOOKUP(D3,$I$3:$J:$361,2,FALSE)

FALSE means you expect an exact match while TRUE means you expect an
approximate match.

Biff
 
M

Max

=VLOOKUP(D3,$I$3:$J:$361,2,TRUE)

Try instead:
=VLOOKUP(TRIM(D3),$I$3:$J$1400,2,0)

TRIM is used on the lookup value D3 to remove any extraneous white spaces
which might be throwing the names matching off

The table array: $I$3:$J$1400
is corrected for syntax and extended to cover (perhaps typo in your original
?)

The 4th param, Range lookup, is set to zero (or FALSE) to hunt for an exact
match (since we're matching names, ie text)
 
Top