Return cost with 2 criteria
I have an excel spreadsheet with 2 sheets. I need to return a value based
off of 2 criteria.
Sample Data: First Sheet
A B C
3592 6120 42.6
3691 6120 39.71
3700 6120 47.17
3709 6120 43.6
3592 X911 26.5
3691 X911 26.5
3700 X911 25.75
3709 X911 25.75
Sample Data: Second Sheet
A B C
3691 6120 ?
3700 6120 ?
3709 6120 ?
3691 X911 ?
3700 X911 ?
3709 X911 ?
I could do this manually but I have over 400 number for column A and 1900
for column B.
I would like say. If the number in A on the second sheet is 3691 and x911,
What is the price?
Please assist.
Thanks, AP
|