Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with lookup please
hi guys, im sure this is a easy one im using a lookup function. what i want to do is use and a cross reference. 1a a 2 b 2 b 3a c 4 d 5a e above is what im talking about. formular is =LOOKUP(D1,A1:A5,B1:B5) and that works fine except if the figure i put in D1 isnt exactly the same as in in A1:A5 ie type 3 instead of 3a the result will be the previous line (b) is there a way of doing a exact lookup or some way to return a false or error if it cant find an exact result. i hope that makes sence Scott -- westie13 ------------------------------------------------------------------------ westie13's Profile: http://www.excelforum.com/member.php...o&userid=35490 View this thread: http://www.excelforum.com/showthread...hreadid=552635 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
help with lookup please
.. =LOOKUP(D1,A1:A5,B1:B5)
Try VLOOKUP with the 4th param set to zero (or FALSE) for an exact match: =IF(D1="","",VLOOKUP(D1,{"1a","a";2,"b";"3a","c";4 ,"d";"5a","e"},2,0)) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "westie13" wrote: hi guys, im sure this is a easy one im using a lookup function. what i want to do is use and a cross reference. 1a a 2 b 2 b 3a c 4 d 5a e above is what im talking about. formular is =LOOKUP(D1,A1:A5,B1:B5) and that works fine except if the figure i put in D1 isnt exactly the same as in in A1:A5 ie type 3 instead of 3a the result will be the previous line (b) is there a way of doing a exact lookup or some way to return a false or error if it cant find an exact result. i hope that makes sence Scott -- westie13 ------------------------------------------------------------------------ westie13's Profile: http://www.excelforum.com/member.php...o&userid=35490 View this thread: http://www.excelforum.com/showthread...hreadid=552635 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |