I may be overthinking this but I'm trying to get my formula to look at the cell below if the results come back with "NA". Is this possible?
In this case, if B2 comes back as "NA", then I want the formula to point to B3 instead.



IF(ISNA(VLOOKUP($B$2,MPS!$D$6:$AF$2492,2,TRUE)),(VLOOKUP($B$3,MPS!$D$6:$AF$2492,2,0)))