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....
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....