Search : in
By :

Vlookup

Last answer on Jul 5, 2009 4:03:43 am BST Lost, on Jul 4, 2009 8:05:32 pm BST 
 Report this message to moderators

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?

Configuration: Windows XP Internet Explorer 6.0

Ask your question Reply

1

 Excelguru, on Jul 5, 2009 4:03:43 am BST

Hi Lost

Try =countif(a1,sheet1!A:A) in sheet 2 cell B1 and then sort/filter Winners are losers who got up and gave it one more try. -Den­nis DeYoung
My Interests are financial Modelling and custom excel develo­pment.

   
Reply to Excelguru
Ask your question Reply
They need your help