C
certain_death
Hi all
Does anybody know how the formula for a multiple vlookup.
I want to lookup against a pivot table that has various customers i
column B and product categories in column H and a sales value in colum
I.
What I want to do is lookup a particular customer and a particula
product and return the sales value.
EG VLOOKUP (Customer A) and VLOOKUP (Product B) and return the sale
value.
Can anyone help??? Driving me mad!!
Many thanks for looking.
Regards
Mark:
Does anybody know how the formula for a multiple vlookup.
I want to lookup against a pivot table that has various customers i
column B and product categories in column H and a sales value in colum
I.
What I want to do is lookup a particular customer and a particula
product and return the sales value.
EG VLOOKUP (Customer A) and VLOOKUP (Product B) and return the sale
value.
Can anyone help??? Driving me mad!!
Many thanks for looking.
Regards
Mark: