LOOKUP

[Dave]

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

 

[Roger Govier]

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

 

[Dave]

Sorry I didnt explain this properly. I need to know the name of the manager
against the reference number? So the April sheet would show: April Manager,
reference number, Jan Manager(being the formula column).

Can this be done. I have tried LOOKUP but this returns the wrong name?

Thanks

 

[Roger Govier]

Hi Dave

If I understand you correctly, then
=INDEX(Jan!B:B,MATCH(A1,JAN!A:A,0))

 

[Dave]

That works! Thanks

Hi Dave

If I understand you correctly, then
=INDEX(Jan!B:B,MATCH(A1,JAN!A:A,0))