lookup in non sorted list

N

Niek Otten

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
Drop down lists in seperate columns 5
Array-friendly functions 1
Excluding a paragraph tag from spelling check 0
Copy addition formula of non-consecutive horizontal cells 2
MS Project 2016 - all tasks not showing in Calendar View 0
Multiple name appearances 1
lookup function?? 2

Top