Match rows between two worksheets and fill empty cells with data from the other worksheets

[sileng000]

Hello there. I'm having trouble with dealing two worksheets, hopefully someone can help me with this.

The problem is that i have two worksheets with customers' information. List1 contains all 2000 customers for our company with Name(Column A), Address(Column B), Tel.(Column C), Email(Column D), Privateemail(Column E), Customercatogory(Column F) and a lot of other information for every customer. However, some cells, except in the Name(column A), are empty. For example, you can find a customer named Tom(A5) with only Address(B5) and Privateemail(E5), but no data in Tel.(C5) and Email(D5). In List2, there are 300 customers with only four columns of Name(Column A), address(Column B), Tel.(Column C), and Email(Column D). Those 300 customers in List2 already exist in the List1, but they may contains information that is missing in List1, such as Tom's Tel. and Email.

Now what i want to do is to fill in the empty cells in List1 with help of the complementary information from List2. I plan to Vlookup all 300 names in the List1 and check if a certain customer's empty information in List1 can be found in List2. If it does, let's say List2 contains data about Tom's Email and address, I would like to copy these data from List2 to C5(Tel.) and D5(Email) in the List1. Is that possible using Vlookup function in combination with some others since i'm not experienced in using VBA.

To sum up, it is basically to match two lists and see if cells in List2 contains info that is missing in List1. Hoepfully I have explained the problem clearly...Any advice would be appreciated!

[nathansav]

Yes, just trap the NA event of VLOOKUP, like if(isna(vlookup),"",vlookup)

[sileng000]

Yes, just trap the NA event of VLOOKUP, like if(isna(vlookup),"",vlookup)

Thank you for your answer. I have tried this formula to identify the empty cells. But I wrote the formula in a new sheet. How would I do if i want to actually fill the blank cells? In which cell the formula should be written? Also, this only work to compare one column on List1 and one on List2. Is that possible to compare several columns as the same time?