View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amber Amber is offline
external usenet poster
 
Posts: 68
Default 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