Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple VLOOKUP problem
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??? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple VLOOKUP problem
=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 "chris" wrote in message ... 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??? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Simple VLOOKUP problem
=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) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "chris" wrote: 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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP problem | Excel Worksheet Functions | |||
Problem with VLOOKUP in 2003. | Excel Worksheet Functions | |||
Vlookup problem.. | Excel Worksheet Functions | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
VLOOKUP problem | Excel Worksheet Functions |