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?

Vlookup
Transfer data from one excel worksheet to another automatically vlookup - Guide
Vlookup if cell contains a word within text ✓ - Word Forum
Vlookup false ✓ - Excel Forum
Vlookup if two cells match return value from third ✓ - Excel Forum
Help Please IF & VLOOKUP Returns - Excel Forum

1 response

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

Similar discussions

Comparing columns and returning value

Match partial text string in one sheet to another text string in another sheet

Lookup partial text contained in cell range

Using Vlookup to return insted of 00/01/1900

add/subtract & vlookup formula

Similar discussions

Subscribe To Our Newsletter!