Adding Numeric Value to Text in Excel 2011

[vaneds]

Hi,

I'm trying to add a number to text. I'm doing research on tweets and I have 2358 tweets in an excel spreadsheet divided into columns with A containing the tweet itself, B containing the username and C containing the date. I want to assign a number to the usernames so that I can do stats on them once I'm done coding.

To help with this I created two columns (G and H), G has the username and H is numbers that I have assigned to the usernames. It looks something like this

Tweeter2luv 1
tweetsalot 2
luvs2tweet 3
tweeter234 4

I want to use this list to then assign numbers to column B (not replace the username but add a corresponding number in a different column). I tried using VLOOKUP but for some reason it's not working at all, it keeps not finding a number for certain usernames and assigning different numbers to the same username.

Anyone know what I can do?

[duffry]

Can you post the formula you are using?

I'm assuming the data in G & H is a list of the usernames with duplicates removed.

Have you checked that you reference this with an absolute reference?
I.e.,
=VLOOKUP(A1,$G$1:$H$10,2,0)
rahter than
=VLOOKUP(A1,G1:H10,2,0)

Have you set the range_lookup to zero or false?

[vaneds]

You are correct my list in G and H is a list of the usernames with all the duplicates removed so it's just the unique usernames.

My formula has been =VLOOKUP(B1,$G$1:$H$1008,2,false) I have not tried setting the range_lookup to zero.

[vaneds]

Can you post the formula you are using?

I'm assuming the data in G & H is a list of the usernames with duplicates removed.

Have you checked that you reference this with an absolute reference?
I.e.,
=VLOOKUP(A1,$G$1:$H$10,2,0)
rahter than
=VLOOKUP(A1,G1:H10,2,0)

Have you set the range_lookup to zero or false?

Just tried setting range_lookup to zero and it worked, YOU ARE MY SAVIOR!!!