Trying to use IF ISBLANK with Index Match

trying to find out if a cell is blank then return a "text" if not then do the INDEX, MATCH here is the formula:

=IF(ISBLANK(TabMD@row),"","text", INDEX({TabletMDM}, MATCH(eCOAID@row, {ecoaid1},0)))

Answers

  • Marcela
    Marcela Employee

    Hello @dharberts

    You can try this formula:

    =IF(ISBLANK([TabMD]@row), "text", INDEX({TabletMDM}, MATCH([eCOAID]@row, {ecoaid1}, 0)))

    This formula checks if the cell in the TabMD column is blank, if true returns 'text', otherwise performs an INDEX and MATCH to find the corresponding value in the TabletDM range based on the eCOAID value.

    Hope this helps!

    Need more information? 👀 | Help and Learning Center
    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • dharberts
    dharberts ✭✭✭

    here is what I did:

    =IF(ISBLANK([TabMD]@row),"text", INDEX({TabletMDM}, MATCH([eCOAID]@row, {ecoaid1},0)))

    Returned

    #UNPARSEABLE

  • Marcela
    Marcela Employee

    I believe both of us missed spelled the second ¨ecoaid¨

    =IF(ISBLANK([TabMD]@row),"text", INDEX({TabletMDM}, MATCH([eCOAID]@row, {eCOAID1},0)))

    Need more information? 👀 | Help and Learning Center
    こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions

  • dharberts
    dharberts ✭✭✭

    Found a mistake in the column header name in the formula, this is now what I inserted and the return in

    #CIRCULAR REFERENCE

    =IF(ISBLANK(TabMDM@row), "text", INDEX({TabletMDM}, MATCH(eCOAID@row, {ecoaid1}, 0)))

  • dharberts
    dharberts ✭✭✭

    I'm going to another sheet cell that is populated with a drop down, and wanting to bring that info back. I was using the INDEX, MATCH, but then if it returns and blank I want it to return a "text"

  • dharberts
    dharberts ✭✭✭

    When I just use the INDEX,MATCH and the cell returns as blank usually the return is a #NO MATCH

    I believe it's returning a blank value because its a dropdown cell. Usually if the cell returning is blank it returns a #NO MATCH, and I use the IF(Error(INDEX MATCH, and it works fine

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!