Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sum a row of multiple vlookups | Excel Worksheet Functions | |||
Multiple Vlookups | Excel Worksheet Functions | |||
multiple vlookups | Excel Worksheet Functions | |||
multiple vlookups | Excel Worksheet Functions | |||
Vlookups and multiple returns (again!) | Excel Worksheet Functions |