| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel NPV initial cost in value1 and first year return in value2? | Excel Worksheet Functions | |||
| Current Cost versus Original Cost | New Users to Excel | |||
| Confusion on adding percentage of cost to that cost. | Excel Worksheet Functions | |||
| How to return min, mean, max using criteria? | Excel Worksheet Functions | |||
| How to return min, mean, max using criteria? | Excel Worksheet Functions | |||
Threaded Mode
