- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel - I Need a Wizard
Posted on 3/12/19 at 12:55 pm
Posted on 3/12/19 at 12:55 pm
I had great success the last time I came here for some Excel advice. I hope the wizards can help me again.
I have a worksheet with two tabs.
Tab 1 Column A lists an asset name.
Tab 1 Column B lists the location of the asset.
Tab 1 Column C,D,E are blank, needs input (from Tab 2).
Tab 2 Column A lists an asset location (without the asset name).
Tab 2 Column B lists an attribute to that location.
Tab 2 Column C lists another attribute to that location.
Tab 2 column D lists a third attribute to that location.
How do I get the data in Tab 2 B,C,D into Tab 1 C,D,E ?
It's about 6000 assets across 636 different locations, which is why I don't want to do this manually.
I have a worksheet with two tabs.
Tab 1 Column A lists an asset name.
Tab 1 Column B lists the location of the asset.
Tab 1 Column C,D,E are blank, needs input (from Tab 2).
Tab 2 Column A lists an asset location (without the asset name).
Tab 2 Column B lists an attribute to that location.
Tab 2 Column C lists another attribute to that location.
Tab 2 column D lists a third attribute to that location.
How do I get the data in Tab 2 B,C,D into Tab 1 C,D,E ?
It's about 6000 assets across 636 different locations, which is why I don't want to do this manually.
This post was edited on 3/12/19 at 12:57 pm
Posted on 3/12/19 at 1:18 pm to deeprig9
Does each tab have a line that uniquely identifies the asset? i.e. a common field If so, vlookup.
This post was edited on 3/12/19 at 1:19 pm
Posted on 3/12/19 at 1:43 pm to deeprig9
quote:
Tab 2 Column B lists an attribute to that location.
Tab 2 Column C lists another attribute to that location.
Tab 2 column D lists a third attribute to that location.
Define attributes vs assets for the purposes of this.
quote:
It's about 6000 assets across 636 different locations, which is why I don't want to do this manually.
I'm asking if the assets you discuss here are the asset name in Tab A or the Attributes in Tab B. In other words is there 1 attribute name per attribute location or multiple.
Vlookup sounds like a good option. it may be even easier if the number of rows in Tab A and Tab B are equal (one row per location).
Posted on 3/15/19 at 9:37 pm to deeprig9
turn both into tables and then use a power query to do a full join to produce the dataset. you'll select location as the column in the menu option.
should have read further vlookup works too.
should have read further vlookup works too.
This post was edited on 3/15/19 at 9:39 pm
Back to top
Follow TigerDroppings for LSU Football News