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
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

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.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,534
Messages
5,572,743
Members
412,482
Latest member
arooshrana2
Top