what excel function do i use for multiple if conditions to read result from data table
Sheet 1 conditions are Column L and Column M. These need to meet a data source specified on the data sheet. This then needs to pull the column n result automatically from the data table on the data sheet.
I have used data validation for the code and term data input (this ensures the values are always in the data lookup). for the cost value I have used Vlookup with row and column selected by match for the code and term values.
Revised spreadsheet attached with changed cells highlighted