Automatic match


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: 
256; Max
354; Tom
763; Jim
85; Sara

Sheet 2:
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. 


By: Noa Isralowitz

515 thoughts on “Automatic match

  1. Bookstore movers

    One more thing I would like to express is that in place of trying to match all your online degree courses on days of the week that you end work (since the majority of people are drained when they get back), try to receive most of your classes on the weekends and only one or two courses for weekdays, even if it means taking some time off your saturdays. This is fantastic because on the saturdays and sundays, you will be more rested in addition to concentrated in school work. Thx for the different tips I have figured out from your site.

  2. african people

    Thanks a bunch for sharing this with all of us you actually realize what you are speaking about! Bookmarked. Kindly also visit my site =). We may have a link change contract among us!

  3. cruise for family of 5

    Have you ever thought about creating an ebook or guest authoring on other websites? I have a blog based upon on the same ideas you discuss and would really like to have you share some stories/information. I know my audience would appreciate your work. If you’re even remotely interested, feel free to send me an e mail.

Leave a Reply

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