Lookup

[Dowsey1977]

I have a table with loads of rows in it on 1 sheet of a spreadsheet. I also have another sheet with fewer rows. I need to compare the 2 sets of information and find out if there are any extra records on the 2nd sheet that aren't on the first. Is there any way of getting Excel todo this, so I don't have to do it manually?

 

[cherria]

You can use VLOOKUP. Can you tell us a bit more about the structure of the spreadsheet, specifically, is there a key field which yuo would use to say this item is the same, or this item is extra and not included in the list.

 

[Dowsey1977]

Ther first sheet has got loads of information in it, call it sheet 1. Sheet 2 has just the one column. Column C is the in sheet 1, and this is the column which should match column A in sheet 2.

Each record is unique in column C, so I need to know the ones that are in sheet 2, but not sheet 1.

 

[cherria]

Ok, in sheet 2 column B starting at B1 (or B2 if yo uhave a header row)

enter this formula

=IF(ISERROR(VLOOKUP(A1,sheet1!$C$1:$C$999,1,false)),"Not Found","Found")

Change the C999 to whatever length your table in sheet1 is

then paste the formula down the length of column B as far as your data in sheet2 goes.

 

[Dowsey1977]

Perfect, many thanks!!

ray: ray: