Using VLOOKUP to link data on separate sheets

[Meli]

Hello,

I have numbers in Colomn A on one sheet. On a second sheet I have the same numbers in Colomn A as well as names in colomn B. I would need the names linked with the numbers from the second sheet to appear next to the appropriate numbers on the first sheet.

I am trying to use VLOOKUP, but cannot get it to work properly. Ideally, I would like the result to be exact, not approximate. Perhaps with FALSE?

Thank you so much for your help!!

[Hang Glider]

yes, with FALSE

=Vlookup(cell to look up in column A, Array [other sheet, from column a1 to bxxx, column to bring over [2?]], false)

looks like this:

=VLOOKUP(A1,'[Other sheet.xlsx]Sheet1'!$A$1:$B$99,2,FALSE)

Beware, if it's just on another tab in the same sheet, the array doesn't "lock" and will float as you copy the formula.

[jake.masters]

All of your values on the first sheet had a blank space at the end, so I used LEFT to get rid of that value. They now match. Your formula was fine, I just switched the 1 to a false.

For example, "Tom" and "Tom " look the same in a cell, but the second one has a space, which causes VLOOKUP to not calculate the two values as equal.

[Hang Glider]

Good catch, Jake.
AbleBits.com has a free plug-in for Excel that strips extra spaces from a selected column/row. I use it a lot, because the files sent to me are often from a database with a set number of characters in a field - and it packs spaces to fill the requirements of the field - which causes the same problem.

(I am not affiliated with above site, only sharing info about freeware that I found helpful)

[jake.masters]

That is something I would be interested in...it says 15 day free trial and after that it is $20. Is that like WinZip where they never collect, or have they just recently started charging?

EDIT: Sorry to go off topic, this just sounds like a great tool.

[Meli]

Amazing! It works perfectly now, thank you so much!