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 COMPANYOFFICETEAMACCOUNT2501RED100016840010062501RED100016840010062501RED100016840010062501RED100016840010062501RED100016840010062501RED100016840010062501RED100016840010062501RED100016840010062501RED100016840010062501RED100016840010062048WEI100017640010062048WEI100017640010062048WEI100017640010062048WEI100017640010062048WEI100017640010062048WEI10001764001006 Lookup Tables Base Level CodeBase Level Alias2048Test Entity2501Test Entity 2

2 files - source and Hierarchy (Vlookup or Find and Replace)

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

Topic of Interest

Accepted answers

rbarco

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!

Find and replace v2.yxzp

All comments

rbarco

Hi @Arkouda,

If you want to use find and replace tool remember that comparing fields must be strings.

Find and replace.png

I've attached a solution based in your sample.

Find and replace.yxmd

Arkouda

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

Source Test Alteryx.xlsx

Hierarchy.xlsx

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703