LOOKUP
Hi
Assuming the Customer number is in A, and Manager in B on both sheets, then
on a third sheet, create a list of Customers in column A
In cell B1 of new sheet
=INDEX(Jan!B:B,MATCH(A1,Jan!A:A,0))=INDEX(Apr!B:B, MATCH(A1,Apr!A:A,0))
This will return a series of True and False
--
Regards
Roger Govier
"Dave" wrote in message
...
Hi, I have a sheet with customer reference numbers and corrsponding
managers
for the month of April. I have the same sheet for the month of January. I
need to see if there have been any changes to the managers by looking at
the
customer reference number.
How do I do this?
Thanks
|