Previous Topic Next Topic

Vlookup

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

Réponse 1 / 1
Excelguru Posts 261 Registration date Saturday 11 April 2009 Status Member Last seen 21 June 2011 307
4 Jul 2009 à 23:03
Hi Lost

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

Similar discussions

How to invoke VLookUp function in Excel VBA.
Wingie -
TrowaD -

1 response
Excel 2007 Using vlookup function in VBA
gsyrill -
gsyrill -

2 responses
Compare values in two columns and return the value from third
ramdubai -
keshav -

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

2 responses
Removing "FALSE" from an IF statement with a VLOOKUP
RayRay -
RayRay -

2 responses