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

2,564 thoughts on “Automatic match

  1. eyfas.com

    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!

  4. iamgutsclub.com

    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.

  7. https://poboleda.org/

    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.