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
-
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 -
here is what I did:
=IF(ISBLANK([TabMD]@row),"text", INDEX({TabletMDM}, MATCH([eCOAID]@row, {ecoaid1},0)))
Returned
#UNPARSEABLE
-
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 -
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)))
-
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"
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!