F
FRANKB
I have 25 workbooks with one worksheet on each one. Each
worksheet has entries for 15 engineer names. The name of
each worksheet is in cell A2. The engineer names begin in
cell A5 - A20. In cells A5 through A20 now have the data
Eng1,Eng2,Eng3, etc etc.
What I would like to is create a lookup table to look at
the file name in cell A2 and the name in cell A5 and if
the file name is (as an example) TTW and the name in cell
A5 is Eng1 put in the engineer's name (example John Smith).
The next would be A2 = TTW, and A5 is Eng2 so the
engineers name is (example Bob Jones). Etc etc.
There are 345 names so I dont' what to have to put these
in each and every workbook so I thought a vlookup table
would do the trick.
Thanks
Frank
worksheet has entries for 15 engineer names. The name of
each worksheet is in cell A2. The engineer names begin in
cell A5 - A20. In cells A5 through A20 now have the data
Eng1,Eng2,Eng3, etc etc.
What I would like to is create a lookup table to look at
the file name in cell A2 and the name in cell A5 and if
the file name is (as an example) TTW and the name in cell
A5 is Eng1 put in the engineer's name (example John Smith).
The next would be A2 = TTW, and A5 is Eng2 so the
engineers name is (example Bob Jones). Etc etc.
There are 345 names so I dont' what to have to put these
in each and every workbook so I thought a vlookup table
would do the trick.
Thanks
Frank