Match and insert

[BingoGeorge]

Hi there,

I have to sheets on excel

SHEET 1

[TABLE="width: 500"]
<tbody>[TR]
[TD]name[/TD]
[TD]ID[/TD]
[TD]Employee[/TD]
[/TR]
[TR]
[TD]JOHN[/TD]
[TD]5456456456[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]FRED[/TD]
[TD]141541546[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]JANE[/TD]
[TD]13131531[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Sheet 2
[TABLE="width: 500"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Employee[/TD]
[/TR]
[TR]
[TD]5456456456[/TD]
[TD]B123123[/TD]
[/TR]
[TR]
[TD]141541546[/TD]
[TD]B565413[/TD]
[/TR]
[TR]
[TD]13131531[/TD]
[TD]B54546[/TD]
[/TR]
</tbody>[/TABLE]


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;">[TABLE="width: 500"]
<tbody>[TR]
[TD]13131531[/TD]
[/TR]
</tbody>[/TABLE]
</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]

[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[TD]

D​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]name[/TD]
[TD]ID[/TD]
[TD]Employee[/TD]
[TD]sheet1[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]JOHN[/TD]
[TD]

5456456456​

[/TD]
[TD]B123123[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]FRED[/TD]
[TD]

141541546​

[/TD]
[TD]B565413[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]JANE[/TD]
[TD]

13131531​

[/TD]
[TD]B54546[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

A​

[/TD]
[TD]

B​

[/TD]
[TD]

C​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]ID[/TD]
[TD]Employee[/TD]
[TD]sheet2[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]

5456456456​

[/TD]
[TD]B123123[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]

141541546​

[/TD]
[TD]B565413[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]

13131531​

[/TD]
[TD]B54546[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

sheet1

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