Use of WHERE clause in excel

Hello - I am trying to update a customer lsit I have in one spreadsheet with the tax resalenumbers from another spreadsheet. The destination spreadsheet has 10,000+ records, the source spreadsheet has 111 records. The current formula I have is:
=IF(B2=[resalenumbers.xls]Sheet1!$A$2,[resalenumbers.xls]Sheet1!$B$2,AB2)

Which compares customer names(A2), if they are equal then it gives me the resale number field (B2source & AB2result).

The problem is I need to have it evaluate for each record in the destination to find the matching record in the source if it exists. Right now it will only do a 1 to 1 comparison rather than a 1 to many.

Any ideas?

If you are expecting single matches, have you tried using a vlookup?
SQL would probably be the best bet, but sometimes we're just stuck with Excel.

If you are expecting multiple results that are non-unique, you will have to search this forum for multiple vlookups and have it added to your module. Apologies in advance: I could not find the one I looked at last week.

However, if you are expecting single results and don't know how to do a vlookup, pls reply. If you do...sorry for wasting your time.

Originally Posted by Lovelock, David

Hello - I am trying to update a customer lsit I have in one spreadsheet with the tax resalenumbers from another spreadsheet. The destination spreadsheet has 10,000+ records, the source spreadsheet has 111 records. The current formula I have is:
=IF(B2=[resalenumbers.xls]Sheet1!$A$2,[resalenumbers.xls]Sheet1!$B$2,AB2)

Which compares customer names(A2), if they are equal then it gives me the resale number field (B2source & AB2result).

The problem is I need to have it evaluate for each record in the destination to find the matching record in the source if it exists. Right now it will only do a 1 to 1 comparison rather than a 1 to many.

Any ideas?

I too am having a similiar problem. I have a large record that I want to filter out only the information I need which I have listed on the worksheet also. I have tried lots of things(vlookup,match,if statements) but have never had any luck. Pikapika13, I would like your input with the vlookup (can these be text).

Thanks,

Adam