Match Data from two separate excel sheets (same excel workbook).

[UTSRP]

Help!! I have one excel workbook with two separate sheets. Sheet 1 has a list of names (Last name in column A, First name in column B). Sheet 2 has a list of names (Last name in column A, Middle name in Column B, First name in column C, EID in column D, and a Username in column E). I need to match the EID and Username from Sheet 2 to the names on Sheet 1 so I can batch upload my information to our system. I need to do this by their names. How can I get this done?

Thanks,

Robert

 

[Veritan]

Hi Robert, if you're looking for a formula, INDEX-MATCH is great for this. This is a two step process, though, make sure you follow these instructions exactly.

First, put this formula in cell C2 on Sheet1 (assuming that is the row you are starting at):

=INDEX(Sheet2!D:D,MATCH(A2&B2,Sheet2!A:A&Sheet2!C:C,0))

IMPORTANT: Do NOT press Enter!! You need to press Ctrl + Shift + Enter. This will put some curly braces "{ }"around the formula.
IMPORTANT: Do NOT put the curly braces in yourself, you need to let Excel do that for you.

Then drag the formula down like you would any other formula. For the Username, use the exact same process with this formula:

=INDEX(Sheet2!E:E,MATCH(A2&B2,Sheet2!A:A&Sheet2!C:C,0))

See if this helps. Good luck!