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
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
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
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
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.
