Replace #N/A of a Vlookup with Another Vlookup

Hi there,

I'm trying to replace the #N/A in a vlookup with another value from a vlookup, but all I'm getting is an #N/A. When I trace my error, excel says the issue is in the first vlookup, but that is what I'm trying to replace! It's as if the two if statements are not connected

Here is my formula


=IF(ISNUMBER($A10),VLOOKUP($A10,INRspot,2,FALSE)),IF(ISNA(VLOOKUP($A10,INRspot,2,FALSE)),VLOOKUP(Sheet1!$J18,INRSpotHaver,1))

It's probably something tiny that I'm not seeing--two heads are better than one!!

Any help is really appreciated

Just solved it. My If statements weren't nested correctly

Here's the correct formula

=IF(ISNA(IF(ISNUMBER($A10),VLOOKUP($A10,INRspot,2,FALSE))),VLOOKUP(Sheet1!$J18,INRSpotHaver,1),IF(ISNUMBER($A10),VLOOKUP($A10,INRspot,2,FALSE)))