=IF(AND(C12=1,C13=1),INDEX(S9:S109,MATCH(C21,M9:M109,0)),0)
All cells and ranges in the formula are formatted as 'Accounting'. At present, the majority of the time an exact match will be found with C21 in M9:M109. Occasionally, an exact match isn't found, and on this occasion I'd like the closest value in M9:M109 to be matched and the corresponding value in S9:S109 to be returned. Can anyone help? Thanks.
Bookmarks