| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula to return value from multiple sheets if volume matched
I have a worksheet with average unit prices for <=50k,
<=100k,<=200k,<=300k,<500k and am creating a cover worksheet which will pull the relevant unit cost based on the volume entered. EG, I have a volume of 150k so I want the formula to take the price from the <=100k sheet. I originally did the formula for sum(if xxx) but it added each unit price instead of looking for the correct volume price. Tried this but have an error - anyone able to help me ? =if(IF(E8<=50000,'=50k pricing sheet'!AB7,IF(E8=199999,'=100k pricing sheet'!I7,IF(E8=299999,'=200k pricing sheet'!I7,IF(E8=499999,'=300k pricing sheet'!I7,IF(E8=500000,'=500k pricing sheet'!AB7)))))) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp or other function to return matched data from multiple col | Excel Discussion (Misc queries) | |||
| Need help with Hlookup - need to return values below the matched c | Excel Worksheet Functions | |||
| Return matched value 2 criteria | Excel Worksheet Functions | |||
| Return Formula results to specific row of matched criteria | Excel Worksheet Functions | |||
| Return Title to matched column | New Users to Excel | |||
Threaded Mode
