Long story short i have a a spreadsheet that is exported from a program. it lists various items that are assigned to different consultants. this program does not have the consultants managers. I need to add a column in which i can input a look up function to read the consultant name and provide the team managers name.
i.e.
Tab1
column A is consultant names
Tab2
column A is consultant names (exactly how they would appear on Tab1)
column B is consultant's Manager name
I've tried
" =lookup(Tab1!A1, Tab2!A:A, Tab2!B:B) "
it's providing manager names but completely wrong ones. Am i missing something... i imagine i am.
Thanks for your time.
Bookmarks