Multiple Column look up

  • Thread starter Thread starter Multiple Column look up
  • Start date Start date
M

Multiple Column look up

In addition to my question, here is the formula I used, which didn't work.
=SUMPRODUCT(--(BU=U118),--(GL=Y118),--(AC=X118),Cat)

The BU, GL, AC and Cat are names of my ranges.

Please help.
 
Make sure that the sizes for each range are the same. Also, unless
you're using Excel 2007, SUMPRODUCT will not accept whole column
references.

Hope this helps!

http://www.xl-central.com

Multiple Column look up
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple column look up 2
Merging multiple columns into one column (dynamically) 1
Multiple Consolidation Pivot table 1
Summarizing with multiple conditions - Formula solution needed 2
Search two columns in list for first and last name and return Id 4
Insert row on multiple sheets 6
A bit of a complicated Array that I can't figure out! HELP! 6
Counting rows with two arguments 7

Back
Top