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)))
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)))
-
This worked perfectly! Thank you so much!
-
Awesome. Glad this worked for you!
Help Article Resources
Categories
Check out the Formula Handbook template!