help writing formula to merge two worksheets

[mrfisherman2010]

I need help writing a formula. I am trying to update one worksheet based on a matching column from another worksheet.

Worksheet 1: ecEveryoneElse
The NewUserName column in this worksheet contains the new data. There are 98000 records in this worksheet.

+---------------+---------------+
| A             | B             |
+---------------+---------------+
| UserName      | NewUserName   |	
+---------------+---------------+
| 3282384       |2wsUShrwj45h   |				
| 2293848       |38Ssjdjr423s   |						
| 2047765       |2OSIv0s4i348   |
+---------------+---------------+

Worksheet 2: llo_studentsdemo
The myNewID (B) column in this worksheet needs to be updated when id matches UserName from the other worksheet. There are 133000 records in this worksheet. I need to do this for all records in this worksheet. Also, there are several records with matching id values in this worksheet.

+---------------+---------------+---...
| A             | B             | C
+---------------+---------------+---...
| id            | myNewID       | nextColumn
+---------------+---------------+---...
| 3282384       | (value is 2wsUShrwj45h after query runs)
| 2293848       | (value is 38Ssjdjr423s after query runs)
| 2047765       | (value is 2OSIv0s4i348 after query runs)
+---------------+---------------+---...

Here is what I want to do:

if ecEveryoneElse.UserName = llo_studentsdemo.id
set llo_studentsdemo.myNewID = ecEveryoneElse.NewUserName
end

Any help writing this formula would be very much appreciated.

Thank you.

Mike

 

[VoG]

Try in Sheet2 B2 and copied down

=VLOOKUP(A2,Sheet1!A:B,2,FALSE)

 

[mrfisherman2010]

My experience with excel formulas is very limited. I'm trying to write the formula and I keep getting syntax errors. I may not be referring to the worksheets and ranges correctly.

 

[VoG]

Show us what you have tried.

 

[mrfisherman2010]

If I paste this into B2 of the llo_studentsdemo worksheet I get N/A.

=VLOOKUP(A2,ecEveryoneElse!A:B,2,FALSE)

 

[VoG]

That means that it isn't finding a match. This should help you to troubleshoot http://www.contextures.com/xlFunctions02.html#trouble

 

[mrfisherman2010]

When there is a match, the correct value is posted into worksheet llo_studentsdemo column B. This is correct.

However, when there is no match I get N/A. Thanks for the tips. I'm getting closer I can feel it.

 

[VoG]

Which version of Excel are you using?

 

[mrfisherman2010]

Mac 2008

 

[VoG]

Try

=IF(ISNA(VLOOKUP(A2,ecEveryoneElse!A:B,2,FALSE)),"",=VLOOKUP(A2,ecEveryoneElse!A:B,2,FALSE))