- 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: Formula 1 chief appalled to find team using Excel to manage 20,000 car parts
Posted on 3/21/24 at 5:48 am to ApisMellifera
Posted on 3/21/24 at 5:48 am to ApisMellifera
Vlookup can't look left, xlookup is where it's at.
Sumifs by category would work fine for QOH totals so who knows how they have this thing setup!
It is kind of shocking with the money that these teams have that they're using Excel for anything other than financial data.
Sumifs by category would work fine for QOH totals so who knows how they have this thing setup!
It is kind of shocking with the money that these teams have that they're using Excel for anything other than financial data.
Posted on 3/21/24 at 6:04 am to SB9513
quote:
Vlookup can't look left, xlookup is where it's at.
Posted on 3/21/24 at 6:49 am to SB9513
quote:
xlookup is where it's at.
yup.
Posted on 3/21/24 at 8:08 am to SB9513
quote:
Vlookup can't look left, xlookup is where it's at.
Naw mane. Index and match.
Left, right, and multiple criteria. And it works on older versions of excel, too.
BUT - I agree there are way better business systems catered specifically for inventory control.
This post was edited on 3/21/24 at 8:10 am
Posted on 3/21/24 at 8:12 am to SB9513
quote:this guy knows.
Vlookup can't look left, xlookup is where it's at.
I was very happy when I discovered xlookup and got to throw vlookup in the trash.
This post was edited on 3/21/24 at 8:13 am
Popular
Back to top
Follow TigerDroppings for LSU Football News