N Niek Otten Feb 15, 2008 #2 No. Use VLOOKUP (or HLOOKUP) instead, with the 4th argument set to FALSE -- Kind regards, Niek Otten Microsoft MVP - Excel | Is there a function to use lookup in non-sorted (but unique) list?
No. Use VLOOKUP (or HLOOKUP) instead, with the 4th argument set to FALSE -- Kind regards, Niek Otten Microsoft MVP - Excel | Is there a function to use lookup in non-sorted (but unique) list?
R Ron Rosenfeld Feb 15, 2008 #3 Is there a function to use lookup in non-sorted (but unique) list? Click to expand... VLOOKUP, HLOOKUP and MATCH can all work on unsorted lists -- see HELP for how to do that. --ron
Is there a function to use lookup in non-sorted (but unique) list? Click to expand... VLOOKUP, HLOOKUP and MATCH can all work on unsorted lists -- see HELP for how to do that. --ron
