Sep 16 2019 09:01 PM
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
Sep 16 2019 09:46 PM
SolutionPlease 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.
Sep 22 2019 07:56 AM
worked like charm!
thanks @Subodh_Tiwari_sktneer
Sep 22 2019 11:12 AM
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.
Sep 16 2019 09:46 PM
SolutionPlease 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.