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


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))



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!