View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Epinn Epinn is offline
external usenet poster
 
Posts: 605
Default formula to lookup value and return value from cell at left of

Please ignore my previous posts on sorting.

If I understand correctly, both VLOOKUP and MATCH require sorting in the same manner.

FALSE - no sorting required
TRUE - column where lookup_up value is in must be sorted in ascending order

I think I am okay now.

Epinn

"Epinn" wrote in message ...
Of course, I forgot about that. But for MATCH, it *never* requires sorting, right?

See what I mean about learning the big picture. I think we all learn better when we connect. Thanks for reminding me.

Cheers,

Epinn

"Kevin Vaughn" wrote in message ...
Actually, if the last argument to vlookup is false (or 0) meaning you want to
find an exact match, the lookup range does not need to be sorted.
--
Kevin Vaughn


"Epinn" wrote:

It just dawned on me that the other rule might be this.

VLOOKUP - Leftmost column must be sorted in ascending order.

MATCH - Array doesn't have to be sorted.

Tony, I hope you don't mind me showing up. When I learn, I usually like to look at the big picture.

Epinn


"Carim" wrote in message ups.com...
Hi Epinn,


If I am mistaken, this was at least the rule ....
in order to vlookup "on the left", one had to combine match and index
to come up with the result ...

HTH
Cheers
Carim