IF/IF and then...

[jjmktg]

I have a "master" spreadsheet with customer number, product numbers and several columns of other information. I sent it out to reps and asked them to update only their customers, and only the product use column if that had changed. So what I need to do is open the returned spreadsheet and post only the changes.

On the master spreadsheet I need a formula to say IF you find the exact customer number match AND you find the exact prodcut number match for the customer, THEN put the use in the cell. The master has all 27000 rows and the returned spreadsheets usually have only about 10-20.

Something like =if(customer number matches)AND IF(product number matches)THEN put in the new customer use.

How do I format that?

 

[Ruddles]

Without seeing your data it's difficult to give you specific advice but I would approach this by creating a unique key for each record in your master worksheet by concatenating the customer number and product number in an additional column somewhere and doing the same to the returned worksheets.

Then you can do something like:-

=vlookup(uniquekeyinmastersheet,datainreturnedsheet,columnwithusefigure,false)

Check out the VLOOKUP function and try using it against a small sample of dummy data to make sure you're happy with the way it works, then consider my suggestion about creating unique keys.