Log In
Register
Home
January 30, 2020
Offline
Hello there,
Im building a "Short Pick" program for my warehouse staff.
I have in column H locations with QTY in I and K with various locations for inventory to go too check stock.
I have also in column U where im taking information from column N where if a list of locations that are predicated on 3 factors "LVL 5", "Buffer" , "Replen" stock. IF
1. Column M is "No stock" then " Re-check" location however its giving a "False" statement in column U.
Can someone tell me if im doing something wrong here??
Thanks
Steve
October 5, 2010
Offline
Hi Steven,
Can you please supply your file rather than a PDF. With the PDF I can't see what data is in the cells and I can't see all the formula.
regards
Phil
January 30, 2020
Offline
Hi Phil,
I tried blowing it up.
Cant really upload file its too big.
If it doesnt work ill have to try another way later
Steve
Trusted Members
October 17, 2018
Offline
Hi Steven, these attachments are not a file as Philip requested, they're still pdfs.
I also suggest you tell us the Excel version you're using. Make sure that the data is anonymized
Trusted Members
Moderators
November 1, 2018
Offline
Your first version of the formula didn't have the additional text argument after "Replen" that your second version does have. The second one shouldn't ever produce False as far as I can see.
1 Guest(s)
