LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
certain_death
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sum a row of multiple vlookups jtgostars Excel Worksheet Functions 1 December 10th 05 06:37 PM
Multiple Vlookups shaj Excel Worksheet Functions 2 November 18th 05 06:32 PM
multiple vlookups inthestands Excel Worksheet Functions 0 January 13th 05 06:35 PM
multiple vlookups inthestands Excel Worksheet Functions 1 January 12th 05 09:07 PM
Vlookups and multiple returns (again!) Domenic Excel Worksheet Functions 0 November 4th 04 02:49 PM


All times are GMT +1. The time now is 04:54 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"