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

**leelnich** · 12-20-2017, 10:07 AM

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

**Natejss** · 12-20-2017, 01:31 PM

Done and done. Thanks my friend. You truly are a guru extraordinaire.

**Natejss** · 12-21-2017, 02:20 AM

So, I've adjusted my spreadsheet a little bit. I've changed the necessary column reference numbers, I'm using the same process and the very same formula, but for some reason the it's not functioning the way it had before. I'm really hoping you can take a look and tell me where I've gone wrong.