Trying to populate a clumn by matching 2 others.

**okcjeeper** · 03-02-2012, 09:54 AM

I have a spreadsheet that has Sheet1 and Sheet 1. Column A on both sheets is a customer number. I want to match those and then pull in the data from column C on sheet2 to column C on sheet1 but only if Column A matches on both. I am attaching a sample sheet.

**NBVC** · 03-02-2012, 09:57 AM

Try:

=VLOOKUP(A2,Sheet2!$A$2:$C$4,3,FALSE)

adjust ranges to suit

copied down

**okcjeeper** · 03-02-2012, 10:09 AM

That's not going to work. In the actual sheet which i can't upload due to privacy converns is a bit different in that is has many rows. Here's the scenario. Similar setups as the sample.

Sheet 1 has the Customer # column A and ID in column C. In sheet 2 I have Column A cusotmer # and Column C is ID. Not every cell is populated. I need it to look at each row in sheet1 and find the matching Customer # on sheet 2 and fill in the proper ID. Sheet 1 has around 12000 rows and sheet 2 has around 270 rows.

The vlookup does not work.

**NBVC** · 03-02-2012, 10:20 AM

Why exacty doesn't Vlookup work?

**okcjeeper** · 03-02-2012, 10:24 AM

It worked for hte first 2 rows on sheet 1 but once it got to row3 a different customer it bombed out and didn't return any results.

**NBVC** · 03-02-2012, 10:26 AM

Did you change the range: Sheet2!$A$2:$C$4 to suit your database?

**okcjeeper** · 03-02-2012, 10:52 AM

Ok got it working right. I am not sure what it was but recopied and rechanged the range and it worked. Guess a space or something snuck in there.

Really do appreciate the help.

**NBVC** · 03-02-2012, 10:57 AM

Great!

If you are satisfied with the solution provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save