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?" |
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?" |
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?" |
All times are GMT +1. The time now is 07:43 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com