Vlookup to SHow corresponding info

[CreativeRova]

Hi,

I have a table of info in in Column a has a bunch numbers all different. Column B shows names. i then have a separate spreadsheet with numbers similar to first spread sheet column A.

I want to check that the number that is in spreadsheet 2 if it appears in spreadsheet 1 then to show the name that is next to the number. see below.

[TABLE="width: 500"]
<tbody>[TR]
[TD]1254
[/TD]
[TD][/TD]
[TD]John Smith
[/TD]
[TD][/TD]
[TD]269
[/TD]
[TD]Steph Johnson
[/TD]
[/TR]
[TR]
[TD]3562
[/TD]
[TD][/TD]
[TD]Bob Wright
[/TD]
[TD][/TD]
[TD]4259
[/TD]
[TD]Belinda Carter
[/TD]
[/TR]
[TR]
[TD]4541
[/TD]
[TD][/TD]
[TD]Simon Jones
[/TD]
[TD][/TD]
[TD]43637
[/TD]
[TD]Simone Hobbs
[/TD]
[/TR]
[TR]
[TD]3254
[/TD]
[TD][/TD]
[TD]Felix Unger
[/TD]
[TD][/TD]
[TD]3562
[/TD]
[TD]Joe Blog
[/TD]
[/TR]
[TR]
[TD]3526
[/TD]
[TD][/TD]
[TD]Joe Blog
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]269
[/TD]
[TD][/TD]
[TD]Steph Johnson
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4259
[/TD]
[TD][/TD]
[TD]Belinda Carter
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]43637
[/TD]
[TD][/TD]
[TD]Simone Hobbs
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12498
[/TD]
[TD][/TD]
[TD]Sarah Fogg
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
As you can see column C has a number in itso i think i need to vlookup that number to column A, if its there then show column B next to that number.

 

[Narendrareddy]

Your Welcome