I have a VLOOKUP formula that currently works:
=VLOOKUP(C2,'2023 RATES'!$A$1:$F$2000,5)
The problem I am trying to solve is if this formula does not find what it is looking for it returns #N/A. Is there a way to add to this formula that if it does not find anything then it would move onto this formula:
=VLOOKUP(D2,'2023 RATES'!$A$1:$F$2000,4)
And then the problem with adding this is there could be multiple times this is found, so it should stop at the first one found.
Can anyone help me?
=VLOOKUP(C2,'2023 RATES'!$A$1:$F$2000,5)
The problem I am trying to solve is if this formula does not find what it is looking for it returns #N/A. Is there a way to add to this formula that if it does not find anything then it would move onto this formula:
=VLOOKUP(D2,'2023 RATES'!$A$1:$F$2000,4)
And then the problem with adding this is there could be multiple times this is found, so it should stop at the first one found.
Can anyone help me?