Try vlookup(A1:sheet2!A1:A100,1,False)

or better

=vlookup(A1:sheet2!A:A,1,False)

and the items flagged #N/A are your missing list

--
Student Wrote:
Hello All,
I am merging two work sheets

the first sheet contains 80 rows and the second sheet contains 194 rows
and
some of these rows are duplicated in sheet 2.

I am using Lookup to determine if the 80 rows from sheet 1 exist in
sheet 2.
So far the lookup function works fine.
However, if a row in sheet 1 is missing in sheet 2 i get the next
larger
value and i don't want that.
when I further resarched it I found the following note about lookup
function.

"If LOOKUP can't find the lookup_value, it matches the largest value
in
lookup_vector that is less than or equal to lookup_value. "

1)I need help with the following:
is there any other function that i can use to return 0 if the value in
sheet
1 is not found in sheet2
2)How can I accomidate the duplicate values in sheet2 ...I do want
these
values to be duplicated in my results too

thank you in advance


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=534525