Lookup or Match??? with separate file.

[mad3]

I have a file called 'managers list' with wirecenter name in column A and Managers name in column B...

Daily - I receive a file called 'orders' with the wirecenter in column A. I want to add a column and have that column look up the associated managers name by checking against column A in daily orders file and cross referencing against wirecenter in 'Managers List' file...

Please help...


Mike in Cali...

 

[mad3]

'managers list'

0801 MAD
0802 BELL
0803 BELL
0804 SMITH
0805 MAD
0806 BELL
0807 MAD
0891 MAD
0892 SMITH
0893 BELL
0894 MAD

ORDERS FILE

COLUMN A, COLUMN B

0803, LOOKUP FUNCTION (WHERE RESULT LISTS MANGER NAME)
0807

 

[John Davis]

'managers list'

0801 MAD
0802 BELL
0803 BELL
0804 SMITH
0805 MAD
0806 BELL
0807 MAD
0891 MAD
0892 SMITH
0893 BELL
0894 MAD

ORDERS FILE

COLUMN A, COLUMN B

0803, LOOKUP FUNCTION (WHERE RESULT LISTS MANGER NAME)
0807

VLOOKUP??

=VLOOKUP(A2,'Managers List'!A2:B12,2,FALSE)