Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple VLookups - Can anyone help me please?
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 | |
|
|
Similar Threads | ||||
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 |