ISBlank to compare cells from worksheets

[cartwell]

I'm quite new to excel and would really appreciate if anyone could help me with this problem. I have two worksheets in the same spreadsheet, the first sheet has approx 1600 records with an id no, companyname etc and the second sheet has the same id no, clientname, etc. The field clientname has similar data to companyname however, there are missing cells in this field. Is there a function I could use to compare both worksheets to complete the missing cells. Something similar to:

=IF(ISBLANK B2:B1600) VLOOKUP(B2:B1600,sheet1!C2:D1567,2,false)

Thanks

 

[NBVC]

Can you use the Vlookup for the entire column? If so, then just use =Vlookup(B2,$C$2:$D$1567,2,false) copied down the entire column

If not, you probably need to add another column next to the Clientname and use a statement like:

=If(B2="",vlookup(b2,sheet1!$C$2:$D$1567,2,false),"") copied down.

Then you can manually move those over to fill in your blanks.