I have a formula that performs an INDEX | MATCH on a table of data based on two input cells. If the inputs are outside the bounds of the data table the result is blank.
The data tables size and contents are static. The inputs used to perform the INDEX and MATCH are [dr]*[/dr].
Could this be easily solved by introducing and IF statement that if the resulting INDEX and MATCH is outside the bounds of the data table the result would appear as '0' (zero)?
Thanks in advance.