Hi All
I have 2 files
1) Source file where I want to look up the name for the Entity Office Team codes to return the description - basically it''s a v lookup in Excel, put the file has multiple tabs to look up the information. I have tried find and replace and other items but can't seem to get the results. I have attached a sample for what I'm trying to archive
Source
COMPANY | OFFICE | TEAM | ACCOUNT |
2501 | RED1 | 000168 | 4001006 |
2501 | RED1 | 000168 | 4001006 |
2501 | RED1 | 000168 | 4001006 |
2501 | RED1 | 000168 | 4001006 |
2501 | RED1 | 000168 | 4001006 |
2501 | RED1 | 000168 | 4001006 |
2501 | RED1 | 000168 | 4001006 |
2501 | RED1 | 000168 | 4001006 |
2501 | RED1 | 000168 | 4001006 |
2501 | RED1 | 000168 | 4001006 |
2048 | WEI1 | 000176 | 4001006 |
2048 | WEI1 | 000176 | 4001006 |
2048 | WEI1 | 000176 | 4001006 |
2048 | WEI1 | 000176 | 4001006 |
2048 | WEI1 | 000176 | 4001006 |
2048 | WEI1 | 000176 | 4001006 |
Lookup Tables
Base Level Code | Base Level Alias |
2048 | Test Entity |
2501 | Test Entity 2 |
Solved! Go to Solution.
Hi @Arkouda,
If you want to use find and replace tool remember that comparing fields must be strings.
I've attached a solution based in your sample.
Hi Barco - thank you for getting back to me so quickly - I forgot to add my attachment where I have one source file and the multiple tab file for Vlookup
Is there a way (i'm sure there is) to look into each tab and pull the information?
Attached is a Source Test File and a Hierarchy file
Hi @Arkouda ,
If there are only 3 sheets to import, the simplest way to achieve it is using the input tool 3 times. I've attached a solution for this.
In case the are more sheets or these are totally different, you will need to create a macro. If this is the case, please check the follow link: Import Multiple Excel Sheets
If this solves your issue please mark the answer as correct, if not let me know!