- 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
re: Excel - I Need a Wizard
Posted on 3/12/19 at 1:19 pm to HurricaneDunc
Posted on 3/12/19 at 1:19 pm to HurricaneDunc
Only the first tab lists the unique asset names.
Posted on 3/12/19 at 1:20 pm to deeprig9
So location is the common field?
Posted on 3/12/19 at 1:34 pm to deeprig9
The way you've explained this, sheet 2 column A should all be different (locations). If that's the case, then.
C2=Vlookup(B2, Sheet2!$A$2:$B$637,2,False)
D2=Vlookup(B2,Sheet2!$A$2:$C$637,3,False)
C2=Vlookup(B2, Sheet2!$A$2:$B$637,2,False)
D2=Vlookup(B2,Sheet2!$A$2:$C$637,3,False)
This post was edited on 3/12/19 at 1:34 pm
Back to top
Follow TigerDroppings for LSU Football News