Can I put a variable row number in an IF function???

MATCH(lookup_value, lookup_array,[match_type]) The zero is the match_type code:

0 = exact match. lookup_array may be unsorted.
1 = approximate match. Finds the largest value less than/equal to. lookup_array must be sorted small to large.
-1 = approximate match. Finds the smallest value greater than or equal to. lookup_array must be sorted large to small.

Here's a decent intro to these and other functions: https://exceljet.net/index-and-match

Also, thank you for the rep! If satisfied, please go to Thread Tools (up top) and mark your thread as SOLVED. Regards - Lee