Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP Problem
I need to use a LOOKUP on the output of a previous LOOKUP, which means my
first LOOKUP output needs to be sorted. Since I am creating an application for use from others, is there a way to autosort the output of a LOOKUP so it can be "LOOKUP'ed again?" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP Problem
The VLOOKUP function has an optional Range_Lookup setting that defaults to
TRUE if left blank. When set to TRUE the lookup peforms an approximate match, which means it looks for the first occurrence of a likely candidate. Example: VLOOKUP(Value, LookupTable,ColumnIndex,[Range_Lookup]) If you set the Range_Lookup option to FALSE it returns an exact match only. Setting the optional argument to FALSE will eliminate the need to sort your lookupd data. -- Kevin Backmann "Bliss" wrote: I need to use a LOOKUP on the output of a previous LOOKUP, which means my first LOOKUP output needs to be sorted. Since I am creating an application for use from others, is there a way to autosort the output of a LOOKUP so it can be "LOOKUP'ed again?" |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
LOOKUP Problem
Have you thought of using INDEX with a MATCH function? For me, the
INDEX-MATCH has replaced the VLOOKUP. Tim "Bliss" wrote: I need to use a LOOKUP on the output of a previous LOOKUP, which means my first LOOKUP output needs to be sorted. Since I am creating an application for use from others, is there a way to autosort the output of a LOOKUP so it can be "LOOKUP'ed again?" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup problem | Excel Worksheet Functions | |||
Help please with a lookup problem | Excel Worksheet Functions | |||
problem with v lookup | Excel Discussion (Misc queries) | |||
lookup problem | Excel Worksheet Functions | |||
Odd problem with LOOKUP | Excel Discussion (Misc queries) |