ISBlank to compare cells from worksheets

cartwell

New Member
Joined
Nov 16, 2005
Messages
1
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
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
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.
 
Upvote 0

Forum statistics

Threads
1,211,452
Messages
6,101,940
Members
447,764
Latest member
gopalgriffith

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top