Is there a formula to get values from B1 if A1 is blank?

hzkid11

I want a formula that will return with the value of cell A1 but if cell A1 is blank, then it will look at the value in B1 and Then I want to do an Index match to a different reference.

This is what I have so far:

=INDEX({Equipment Master Range 3}, MATCH([Asset Number]@row, {Equipment Master Range 4}, 0))

Jeff Reisman

@hzkid11

The syntax would be something like:

=IF(ISBLANK(A1), The Index/Match formula for B1 goes here, The Index/Match formula for A1 goes here)

Does the logic make sense? IF the A1 cell is blank, use the Index/match for B1, otherwise, use the Index/Match for A1.