Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
lookup problem in excel
Hi, the problem I have with lookup is that it doesn't do an exact match. It matches any part of Lookup_value with any part of Lookup_vector and returns the value.
I need it to bring the result_vector only if the Lookup_value is exactly the same as Lookup_vector. if its not exactly the same then put na or what ever it is it puts. The code I am using is =LOOKUP(A2,Sheet2!A2:A53,Sheet2!B2:B53) and what happens is that it doesn't do an exact match, as long as a part of the Lookup_Value matches Lookup_vector it returns the Result_vector. I tried using vlookup and hlookup but they where acting funny and I couldn't get them to work Can some one please help me. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup problem Excel capabilities | Excel Worksheet Functions | |||
EXCEL LOOKUP PROBLEM | Excel Discussion (Misc queries) | |||
Excel 2007 lookup problem continuing ... | Excel Worksheet Functions | |||
Excel 2007 LOOKUP Problem? | Excel Worksheet Functions | |||
LOOKUP Problem | Excel Worksheet Functions |