Vlookup and Match

A

Alfarata

I can not seem to get the Vlookup with Match to work. I would appreciate
any help. I keep getting the wrong answer in the lookup.


thank
Alfarata


+-------------------------------------------------------------------+
|Filename: VlookupTable.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4749 |
+-------------------------------------------------------------------+
 
A

Ardus Petus

There is no error.
Since your VLOOKUP 4th argument is omitted, it defaults to FALSE (0), which
is OK
When looking at 1st argument (120) in column C1:C18, VLOOKUP matches 120
with 97 which is immediately under 120.
The MATCH part of your formula returns the right column number.

You can get the expected result using the following formula:
=INDEX(D11:M18,MATCH(A7,C11:C18,-1),MATCH(A6,D9:M9,-1))
after you sort your whole table on descending order of col. C

See example: http://cjoint.com/?fmhr1lsfee

HTH
 
Top