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

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.

NBVC

Well-known Member
Joined
Aug 31, 2005
Messages
5,828
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.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,802
Messages
5,833,751
Members
430,229
Latest member
TestableEmu263

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
Top