Very simple VLOOKUP, but causing a lot of problem!

Hi all,

I have, what I think at least, a very simple VLOOKUP problem. However, I just can't solve it, and it's driving me nuts. I have 2 sets of 2 columns, in other words 4 columns total. There is a blank column between the two columns. Each set of columns has the column heading Customer and Number, in that order. I am trying to match up the name of the customer in the first set of columns to the name in the 2nd set of columns, and return the number from the second column of the 2nd set into the blank column in the center.

I am using the formula =VLOOKUP(A2,D:E,2), but it's giving weird data.

I have uploaded a sample workbook with dummy variable, but everything else is set up as is in the original document. Any help would be greatly appreciated!

Vlook up practice.xlsx

Just add "FALSE" argument in your formula, its means "Exact Match"

Like this
=VLOOKUP(A2,D:E,2,FALSE)

hope it help

That did the trick, thanks!