ExcelBanter - Complicated look up formula with simple calculation inserted in the formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Complicated look up formula with simple calculation inserted in the formula (https://www.excelbanter.com/excel-discussion-misc-queries/449115-complicated-look-up-formula-simple-calculation-inserted-formula.html)

Excel Dumbo

Complicated look up formula with simple calculation inserted in the formula

Hello friends,

please refer the file attached. the file is untidy. i need to look up values based on multiple conditions and insert simple calculations within look up formula.

Thanks heaps

http://speedy.sh/v9H6y/Complicated-l...th-formula.xls

All times are GMT +1. The time now is 08:59 AM.