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 |
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 |