Forum Discussion
If and vloockup
I have sheet with locations as (Z1-A-1-AA01) and i take all locations that i use and i need to do if the locations use must the other location as (Z1-A-1-AA0102 & Z1-A-1-AA) be blank.
i attached to you the file i will work on it,
Location on Label: in our system.
Available: FYI
Used: the actual in our WH
Thank you. So, what is the task - from "Location on Label" column generate list of values which are not in "Used" column?
- I need to know the locations not bean use in (used)
- Not been used*