Previous Topic Next Topic

Vlookup

Closed
Lost - Jul 4, 2009 at 03:05 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Jul 4, 2009 at 11:03 PM
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

Answer 1 / 1
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Jul 4, 2009 at 11:03 PM
Hi Lost

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

Similar discussions

Lookup partial text contained in cell range
Tom -
Tom -

4 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Match partial text string in one sheet to another text string in another sheet
Santos -
Santos -

2 responses
add/subtract & vlookup formula
sudhir -
sudhir -

2 responses
Find word within cell & put value in adjacent
Mr.G -
BogelBot -

39 responses
Using Vlookup to return insted of 00/01/1900
Tom9o -
tom9o -

2 responses