One way is to put something like, in say J2:
=INDEX($I$2:$I$10,MATCH(1,($B$2:$B$10="Customer A")*($H$2:$H$10="Product
B"),0))
then array-enter the formula, i.e. press CTRL+SHIFT+ENTER
instead of just pressing ENTER

Adapt the ranges to suit ..
(note that entire col ranges cannot be used, eg: B:B, H:H, etc)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"certain_death"
wrote in message
news:certain_death.237tkz_1139913901.5555@excelfor um-nospam.com...

Hi all

Does anybody know how the formula for a multiple vlookup.
I want to lookup against a pivot table that has various customers in
column B and product categories in column H and a sales value in column
I.
What I want to do is lookup a particular customer and a particular
product and return the sales value.
EG VLOOKUP (Customer A) and VLOOKUP (Product B) and return the sales
value.
Can anyone help??? Driving me mad!!

Many thanks for looking.
Regards
Mark:)


--
certain_death
------------------------------------------------------------------------
certain_death's Profile:
http://www.excelforum.com/member.php...o&userid=24561
View this thread: http://www.excelforum.com/showthread...hreadid=512174