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



  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭


    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.


    Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!