Index Match - Returning a blank Value
Hi All,
I am working on using an Index/Match to pull physician email addresses based on their EMP CID, which is stored on a separate physician roster sheet.
=Index({Physician Roster 2024 Email}, MATCH([EMP CID]@row, {Physician Roster 2024 EMP CID},0))
When adding a physician to this sheet, if I leave the EMP CID field blank, it automatically pulls over the email address of the first physician listed on the roster who also has a blank EMP CID field.
Is there a way to write the formula so that only exact matches are pulled and blanks excluded?
Best Answer
-
Hi Lbrady,
Something like this perhaps?
=IF(EMP CID]@row="","",Index({Physician Roster 2024 Email}, MATCH([EMP CID]@row, {Physician Roster 2024 EMP CID},0)))
https://www.linkedin.com/in/zchrispalmer/
Answers
-
Hi Lbrady,
Something like this perhaps?
=IF(EMP CID]@row="","",Index({Physician Roster 2024 Email}, MATCH([EMP CID]@row, {Physician Roster 2024 EMP CID},0)))
https://www.linkedin.com/in/zchrispalmer/
-
This worked perfectly! Thank you so much!
-
Awesome. Glad this worked for you!
https://www.linkedin.com/in/zchrispalmer/
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!