Vlookup

Closed
Report
-
Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
-
Hey,
I have two sheets in one workbook. Sheet 1 is the master and sheet 2 is new information that needs to be added to the master sheet. In column A of the master sheet I need to compare its data to column A of the second (2) sheet to find what is missing from the master sheet. Then I need to add whatever data not found from second (2) sheet to the master sheet.
I would like to use Vlookup but am having some trouble.....Can someone help?

1 reply

Posts
261
Registration date
Saturday April 11, 2009
Status
Member
Last seen
June 21, 2011
307
Hi Lost

Try =countif(a1,sheet1!A:A) in sheet 2 cell B1 and then sort/filter