Vlookup Help Needed

[nander]

Thanks Topper,
Need just a bit more help here, if you would please. In the attached file the CUST worksheet has a column PRICE.POINT AND CO#. I'd like the PRICE.POINT AND CO# corresponding data from the worksheet POINTER to appear in the CUST worksheet by matching the CUST number in the CUST worksheet with the CUST number in the POINTER worksheet. I had to reduce the number of customer in the file to upload to this forum. there may be a chance the customers listed might not have a corresponding customer in the pointer worksheet.

[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

"nander" wrote:

>
> In the attached spreadsheet TEST I have two worksheets. In the worksheet
> CUST I need a VLOOKUP formula that returns a MULTIPLIER in the MULTX
> column that is defined in worksheet TYPE. The type of multiplier a
> customer receives depends on his class and volumn. For instance in the
> CUST worksheet I need the VLOOKUP to look at the TYPE worksheet and
> compare the CUST sales to TYPE workseet volumn and CLASS and return a
> multiplier.
>
>
> +-------------------------------------------------------------------+
> |Filename: TEST.zip |
> |Download: http://www.excelforum.com/attachment.php?postid=4582 |
> +-------------------------------------------------------------------+
>
> --
> nander
> ------------------------------------------------------------------------
> nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
> View this thread: http://www.excelforum.com/showthread...hreadid=529672
>
>