Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Matrix lookup/mulitple criteria lookup | Excel Discussion (Misc queries) | |||
Get Cell Address From Lookup (Alternative to Lookup) | Excel Worksheet Functions | |||
Join 2 Lists - Lookup value in 1 list & use result in 2nd lookup | Excel Worksheet Functions | |||
Sumproduct - Condition based on lookup of a Lookup | Excel Discussion (Misc queries) | |||
Pivot table doing a lookup without using the lookup function? | Excel Discussion (Misc queries) |