- 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 and/or Access Help: Concatenate and Look up
Posted on 11/18/14 at 4:03 pm
Posted on 11/18/14 at 4:03 pm
I am having trouble figuring out a script to help me automate creating unique ID's by using look up tables.
This could either be in Access or Excel.
The first table/sheet has all the names and fields to be concatenated. The remaining tables/sheets have the look up and codes.
I need a way to have a field look up its name in another table/sheet and look to the adjacent column and grab the code then concatenate with the next word.
here is an example of the first sheet with everything to be concatenated to make a unique ID.
Second sheet with look ups:
Third sheet with look ups:
TIA
This could either be in Access or Excel.
The first table/sheet has all the names and fields to be concatenated. The remaining tables/sheets have the look up and codes.
I need a way to have a field look up its name in another table/sheet and look to the adjacent column and grab the code then concatenate with the next word.
here is an example of the first sheet with everything to be concatenated to make a unique ID.
Second sheet with look ups:
Third sheet with look ups:
TIA
This post was edited on 11/18/14 at 4:04 pm
Posted on 11/18/14 at 4:19 pm to Hu_Flung_Pu
=vlookup(a1,sheet2!a:b,2,false)&vlookup(b1,sheet3!a:b,2,false)
This post was edited on 11/18/14 at 4:21 pm
Posted on 11/18/14 at 4:26 pm to Big Data
hell yeah! It worked! Thanks!
Posted on 11/18/14 at 5:13 pm to Hu_Flung_Pu
Is there a way in access with the sheets being tables instead.
Popular
Back to top
Follow TigerDroppings for LSU Football News