- My Forums
- Tiger Rant
- LSU Score Board
- LSU Recruiting
- SEC Rant
- SEC Score Board
- 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 question for you geniuses
Posted on 4/27/24 at 2:50 pm to King Crab
Posted on 4/27/24 at 2:50 pm to King Crab
Serious answer
You need to have a unique identifier in each of the sheets. You said inventory, so maybe a SKU
Copy and paste both data sets onto one sheet (for ease)
Utilize an xlookup and grab the sku and range the quantities.
Index and vlookup work but are now “older” tech and require formatting. X lookup is the formula of gods now.
YouTube is your friend
Oh and you need to learn excel if you want to move up and survive in industry today.
Hope this helps
You need to have a unique identifier in each of the sheets. You said inventory, so maybe a SKU
Copy and paste both data sets onto one sheet (for ease)
Utilize an xlookup and grab the sku and range the quantities.
Index and vlookup work but are now “older” tech and require formatting. X lookup is the formula of gods now.
YouTube is your friend
Oh and you need to learn excel if you want to move up and survive in industry today.
Hope this helps
This post was edited on 4/27/24 at 2:51 pm
Popular
Back to top
Follow TigerDroppings for LSU Football News