Forum Discussion
Marvin Oco
Sep 16, 2019Iron Contributor
FORMULA TO CONVERT LIST OF OLD EMAIL TO NEW EMAIL
What is the FORMULA TO CONVERT LIST OF OLD EMAIL TO NEW EMAIL?
formula results in E should be like this in reference to data in A B and D
please see attached
Please try this and let me know if this is what you were trying to achieve...
=IFERROR(INDEX(B:B,MATCH(D2,A:A,0)),D2)and then copy it down.
3 Replies
- Subodh_Tiwari_sktneerSilver Contributor
Please try this and let me know if this is what you were trying to achieve...
=IFERROR(INDEX(B:B,MATCH(D2,A:A,0)),D2)and then copy it down.
- Marvin OcoIron Contributor
worked like charm!
thanks Subodh_Tiwari_sktneer
- Subodh_Tiwari_sktneerSilver Contributor
You're welcome! Glad it worked as desired.
Please take a minute to accept the post with the proposed solution as an accepted answer to mark your question as Solved.