Vlookup Help Needed

[nander]

In the attached spreadsheet TEST I have two worksheets. In the workshee
CUST I need a VLOOKUP formula that returns a MULTIPLIER in the MULT
column that is defined in worksheet TYPE. The type of multiplier
customer receives depends on his class and volumn. For instance in th
CUST worksheet I need the VLOOKUP to look at the TYPE worksheet an
compare the CUST sales to TYPE workseet volumn and CLASS and return
multiplier

+-------------------------------------------------------------------
|Filename: TEST.zip
|Download: http://www.excelforum.com/attachment.php?postid=4582
+-------------------------------------------------------------------

 

[Toppers]

Try in column I:

=INDEX(TYPE!$A$3:$F$34,MATCH(D2,TYPE!$A$3:$A$34,0),7-MATCH(H2,{0,500,2500,7500},1))

And copy down

hth