Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
vlookup and sorting and references.
I have a data table that has a field with a formula that includes multiple
vlookups and multiple tabs (the array is on a worksheet tab). The lookup value is another cell in the record and that's compared to a value in the array. I'm not using absolute references in the lookup value because I'm checking each record/row in the data table. but I AM using absolute refs in the array (because we don't want each row to advance to a different area of the reference array)... Is there another way to lookup, but not lose my lookup value when I resort the table? Thank you! Derek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sorting Worksheet and how it effects Formulas with cell references | Excel Discussion (Misc queries) | |||
Cell references auto update when sorting | Excel Discussion (Misc queries) | |||
Sorting of References for Formulas | Excel Worksheet Functions | |||
Sorting Data with External References | Excel Discussion (Misc queries) | |||
Sorting lists with references | Excel Discussion (Misc queries) |