SOLVED

Issue writing a formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1504218%22%20slang%3D%22en-US%22%3EIssue%20writing%20a%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1504218%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20struggling%20to%20create%20a%20formula%20to%20do%20what%20I%20need%20it%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%202%20sheets%20in%20a%20workbook.%20Sheet%201%20has%20a%20list%20of%20names%20and%20mailing%20addresses%20without%20email%20addresses.%20Sheet%202%20has%20a%20more%20extensive%20list%20of%20names%20and%20mailing%20addresses%20that%20also%20includes%20email%20addresses.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20goal%20is%20to%20populate%20email%20addresses%20into%20Sheet%201%2C%20so%20I%20want%20to%20make%20a%20formula%20that%20references%20Sheet%202%2C%20and%20if%20there%20is%20a%20match%20I%20want%20to%20populate%20the%20emails%20with%20the%20same%20person%20in%20Sheet%201.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere's%20the%20logic%20that%20I%20am%20trying%20to%20put%20in%20Sheet%201%20Cell%20J2%3A%3C%2FP%3E%3CP%3EIf%20text%20in%20Sheet1%20cell%20B2%20matches%20text%20in%20Sheet2%20Column%20B%20and%20if%20text%20in%20Sheet1%20cell%20A2%20matches%20text%20in%20Sheet2%20Column%20A%2C%20then%20Sheet1%20cell%20J2%20would%20then%20populate%20with%20the%20matching%20email%20address%20in%20Sheet%201%20Column%20J.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAttached%20is%20an%20example%20sheet.%20Thank%20you%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1504218%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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 extensive list of names and mailing addresses that also includes email addresses.

 

My goal is to populate email addresses into Sheet 1, so I want to make a formula that references Sheet 2, and if there is a match I want to populate the emails with the same person in Sheet 1.

 

Here's the logic that I am trying to put in Sheet 1 Cell J2:

If text in Sheet1 cell B2 matches text in Sheet2 Column B and if text in Sheet1 cell A2 matches text in Sheet2 Column A, then Sheet1 cell J2 would then populate with the matching email address in Sheet 1 Column J.

 

Attached is an example sheet. Thank you in advance!

2 Replies
best response confirmed by ericanicole (New Contributor)
Solution

@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.

This worked great! Thank you!