LOOKUP
 

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

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

LOOKUP
 

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" wrote:

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

LOOKUP
 

Hi Dave

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

--
Regards
Roger Govier

"Dave" wrote in message
...
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" wrote:

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

LOOKUP
 

That works! Thanks

"Roger Govier" wrote:

Hi Dave

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

--
Regards
Roger Govier

"Dave" wrote in message
...
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" wrote:

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