Index / Match question or other LOOKUP

S

scott

I think the answer to this question involves the
combination of the INDEX and MATCH function but I'm unable
to get my function to work. Here's my problem.

Row 1 has headings:
A1: Part #
B1: Option
C1: Jan
D1: Feb
E1: Mar

Column A has part numbers:
A2: Part 1
A3: Part 1
A4: Part 1

Column B has options to the part numbers:
B2: Option A
B3: Option B
B4: Option C

The range C2:E4 has the number of units produced for each
part/option combination. In cell A6, I want to put a
formula that will return "How many units were produced for
Part 1,with Option B, in February." I'm essentially doing
a lookup but I need two columns to match - both the part
in Col A and the option in Col B to returns units under
the February heading. I really appreciate your help.
 

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

Index/Match Functions to Return Concatenated Response 4
Problem with SET & REF function 0
Index and Match 8
Match issue 3
=MATCH with nested arrays assistance needed 0
Lookup and match then return data from another sheet 6
Index Match to ignore blank cells 0
Index Match function for lookup HELP 5

Top