| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup
I need to lookup a value in a range that is not sorted.
Vlookup doesn't seem to do the job. I couldn't get Match to do it either. How can I do that? GMet |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lookup
Have you tried using 0 or FALSE as the third argument?
ie =VLOOKUP(item,range,FALSE) ? -- Return email address is not as DEEP as it appears "GMet" wrote in message ... I need to lookup a value in a range that is not sorted. Vlookup doesn't seem to do the job. I couldn't get Match to do it either. How can I do that? GMet |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Lookup
Jack,
That did it!! Thanks GMet -----Original Message----- Have you tried using 0 or FALSE as the third argument? ie =VLOOKUP(item,range,FALSE) ? -- Return email address is not as DEEP as it appears "GMet" wrote in message ... I need to lookup a value in a range that is not sorted. Vlookup doesn't seem to do the job. I couldn't get Match to do it either. How can I do that? GMet . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup help. lookup result based on data in 2 columns | Excel Worksheet Functions | |||
| LOOKUP FUNCTION? (LOOKUP VALUE BEING A TIME RENERATED FROM A FORMU | Excel Discussion (Misc queries) | |||
| Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
| Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
| Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Linear Mode
