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; 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