Forum Discussion
Solved
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.
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.
worked like charm!
thanks Subodh_Tiwari_sktneer
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.