Lookup function and compare
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
|