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

2,564 thoughts on “Automatic match


    Having read this I thought it was rather enlightening. I appreciate you spending some time and effort to put this article together. I once again find myself spending a lot of time both reading and posting comments. But so what, it was still worth it!

  2. moedah

    Aw, this was a really good post. Finding the time and actual effort to produce a superb article… but what can I say… I hesitate a whole lot and don’t manage to get nearly anything done.

  3. 谷歌优化

    It’s a pity you don’t have a donate button! I’d most certainly donate to this excellent
    blog! I suppose for now i’ll settle for bookmarking and adding your RSS feed to
    my Google account. I look forward to fresh updates and will talk about
    this site with my Facebook group. Chat soon!


    Hello! I could have sworn I’ve visited this site before but after going through some of the posts I realized it’s new to me. Anyways, I’m certainly delighted I stumbled upon it and I’ll be bookmarking it and checking back regularly!

  5. App Globo Ao Vivo

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  6. camping

    Your style is unique compared to other people I have read stuff from. Thanks for posting when you’ve got the opportunity, Guess I will just book mark this site.


    This is the perfect webpage for anyone who wants to understand this topic. You realize so much its almost tough to argue with you (not that I really would want to…HaHa). You definitely put a brand new spin on a topic that’s been written about for decades. Wonderful stuff, just excellent!

  8. download vivoslot apk

    I would like to thank you for the efforts you’ve put in writing this site. I am hoping to see the same high-grade content from you later on as well. In fact, your creative writing abilities has motivated me to get my own site now 😉

Comments are closed.