Automatic match

Hi,

Would very much appreciate your assistance tackling the following conundrum: 
I have two separate sheets. 
In sheet 1: I have a column A for numbers and column B for names.
In sheet 2: I have a column C for numbers (some of them are also listed in column A , sheet1) and I would like excel to insert (retrieve) automatically the matching name from sheet 1 in to column D. 

Meaning sheet 1: 
A;B
256; Max
354; Tom
763; Jim
85; Sara

Sheet 2:
C;D
256; auto insert Max
763; auto insert Jim

What would be the function for that? I hope my question is clear, I tried Vlookup but it didn’t work. 

Thanks!

By: Noa Isralowitz

25 thoughts on “Automatic match

  1. suba suba

    l2UTjJ Wow, superb blog layout! How long have you been blogging for? you made blogging look easy. The overall look of your site is excellent, as well as the content!

  2. cognitive bias

    You have made some really good points there. I checked on the internet for additional information about the issue and found most people will go along with your views on this web site.

  3. coach facotory outlet

    Youre so cool! I dont suppose Ive learn anything like this before. So nice to search out someone with some authentic ideas on this subject. realy thanks for beginning this up. this website is something that’s wanted on the internet, someone with a bit of originality. helpful job for bringing one thing new to the internet!

Leave a Reply

Your email address will not be published. Required fields are marked *