Locate row based on two criteria

K

Kathrine

I have a list of data where column A and Column B together identify the row
uniquely.

From a formula I want to locate a specific row matching the TWO criteria
(i.e. both value in A and B columna should match my input values). I want to
return the value in column C.

ex: (list is sorted - A asc, then B asc)
A- Item B-Item location C-Stock Qty
Barbie doll X 10
Barbie doll Y 6
Barbie doll Z 3
Spiderman X 2
Spiderman Y 4

I want to find how many barbie dolls are on location Y (=6) and use this
value for further processing.

Should be simple, but I'm not very advanced in Excel. With only one criteria
I would have used VLOOKUP......

Grateful for any help on this....
 

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

Top