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

One thought on “Automatic match

Leave a Reply

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