Thread: lookup in non sorted list
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default lookup in non sorted list
No. Use VLOOKUP (or HLOOKUP) instead, with the 4th argument set to FALSE

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ron" wrote in message ...
| Is there a function to use lookup in non-sorted (but unique) list?


Reply With QuoteReply With Quote