Vlookup

[kevinaci]

Hey guys, i'm trying to create a database of usernames and guids, i have already update my a database of 1811 entries, with username, and guid. now i need to add the user id to that list on another column. i have a sql dump on another excel file which has the username and user id. how do to create a vlookup to return the user id based on the username from the sql dump? or is there another easier function to use, everytime i try something its says n/a

[darkyam]

Assuming the user names match perfectly, if the sql dump is in a book called SQL and on sheet 1, it should be =VLOOKUP(A1,[SQL.xlsx]Sheet1!$A$1:$B$1811,2,0) copied down.

[kevinaci]

what if i have the name and guid list on sheet 1 and the name and user id copied to sheet 2?

[teylyn]

You mean they are in the same workbook instead of two different files? then just change the reference for the lookup table in darkyam's formula

=VLOOKUP(A1,Sheet2!$A$1:$B$1811,2,0)

[kevinaci]

Well its not working, its returning a N/A

[teylyn]

When Vlookup returns a #NA it means that the lookup value can not be found.

Do a visual check and if you think that the lookup value actually should be found, check if the two cells are really the same. Are there trailing spaces in one of the cells? Then the two cells are not the same, i.e.

"John Doe" is not the same as "John Doe "

You must ensure that your lookup value and the values in the first column of the lookup table match, so you may need to trim off the spaces.

You can insert a column in your lookup table, then enter

=trim(a1)
and copy this down all rows of the table. Now copy the result column and use Paste special - Values to paste it back onto the original data. Delete the column with the formula.

Now check your Vlookup again? does it return the value?

If not, you may want to upload a data sample for further inspection.

cheers