Formula to produce data based on column

All,

I am trying to do something that should be simple but I keep getting errors. I believe I should be using VLOOKUP but it is not working.

I want Excel to look in Sheet2 for the corresponding customer number selected in Sheet1. Then return the City name. Essentially, I have over 700 customers that I need to add city and states to. I have a separate list of all of my 16,000 customers with that information and I need only the 700 desired in sheet one.

I've just noticed that some of your data in Sheet2 has no State, and some have no city. In cases like this you will see zero on Sheet1. You can avoid this by doing the following:

B5: =IFERROR(VLOOKUP(A5,Sheet2!A:C,2,0)&"","")

C5: =IFERROR(VLOOKUP(A5,Sheet2!A:C,3,0)&"","")

Hope this helps.

Pete

Pete,

Thank you very much for that. It is finally working. I appreciate the quick help, wish I knew this forum was here a long time ago

Glad to help, and thanks for marking the thread as Solved. I think the Forum started in 2003, so it has been around for a while.

Since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

Pete