Forum Discussion

ericanicole's avatar
ericanicole
Copper Contributor
Jul 03, 2020
Solved

Issue writing a formula

I'm struggling to create a formula to do what I need it to do.   I have 2 sheets in a workbook. Sheet 1 has a list of names and mailing addresses without email addresses. Sheet 2 has a more extensi...
Need Help
  • Alan_Murray's avatar
    Alan_Murray
    Jul 05, 2020

    ericanicole Please find attached a workbook with a solution. It used INDEX and MATCH functions.

    Also a helper column as I didn't know your Excel version or experience.

    I hope this makes sense.

Alan_Murray's avatar
Alan_Murray
MVP
Jul 05, 2020

ericanicole Please find attached a workbook with a solution. It used INDEX and MATCH functions.

Also a helper column as I didn't know your Excel version or experience.

I hope this makes sense.

  • ericanicole's avatar
    ericanicole
    Copper Contributor
    Jul 07, 2020

    This worked great! Thank you!