I need an excel formula that can do the following ( in the attached excel sheet)
1 . Look up the value from input sheet from rows 8 and 9
2 . Convert the value in row 6 which is in month to completed years. If this is less than 1 then value will be 1. Place this value in row 7 of input sheet
Match the value from rows 7, 8 and 9 to the corresponding value in output sheet to give a final rate for a particular year.