Match and insert

[BingoGeorge]

Hi there,

I have to sheets on excel

SHEET 1

name	ID	Employee
JOHN	5456456456
FRED	141541546
JANE	13131531

<tbody>
</tbody>

Sheet 2

ID	Employee
5456456456	B123123
141541546	B565413
13131531	B54546

<tbody>
</tbody>

What I need is a formula to have the Employee number added to Sheet 1 by matching the ID# from sheet 2.

Thank you!
****** id="cke_pastebin" style="position: absolute; top: 314px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">

13131531

<tbody>
</tbody>

</body>

 

[philwojo]

This should work for you.

=VLOOKUP(B2,'SHEET 2'!$A$2:$B$4,1,0)

Put that in B2 and copy down as necessary. If your data range on Sheet 2 is larger update the $A$2:$B$4 to reflect the larger data group.

 

[BingoGeorge]

when I do this it says "TRUE".

 

[BingoGeorge]

This should work for you.

=VLOOKUP(B2,'SHEET 2'!$A$2:$B$4,1,0)

Put that in B2 and copy down as necessary. If your data range on Sheet 2 is larger update the $A$2:$B$4 to reflect the larger data group.

when I do this it says "TRUE".

 

[philwojo]

I went based on what you typed in terms of sheet names, if you don't have a space between the word 'sheet' and the '2' then remove that space. Just update "SHEET 2" to be whatever your actual sheet name is, I think that is the issue.

If that already matches can you copy and paste in the full formula as you put it on your sheet.

 

[MARZIOTULLIO]

	A​	B​	C​	D​
1​	name	ID	Employee	sheet1
2​	JOHN	5456456456​	B123123
3​	FRED	141541546​	B565413
4​	JANE	13131531​	B54546

<tbody>
</tbody>

	A​	B​	C​
1​	ID	Employee	sheet2
2​	5456456456​	B123123
3​	141541546​	B565413
4​	13131531​	B54546

<tbody>
</tbody>

sheet1

c2=INDEX(Sheet2!$B$2:$B$4,MATCH(Sheet1!$B2,Sheet2!$A$2:$A$4,0)) copy down