If and vloockup

Question

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 &amp; Z1-A-1-AA) be blank.

sergeibaklan · Answer

Mrhussam&nbsp;
Perhaps you may provide sample file to illustrate the question, it's unclear what do you mean.

mrhussam · Answer

i attached to you the file i will work on it,&nbsp;Location on Label: in our system.Available: FYIUsed: the actual in our WH&nbsp;&nbsp;SergeiBaklan&nbsp;

sergeibaklan · Answer

Mrhussam&nbsp;
Thank you. So, what is the task - from "Location on Label" column generate list of values which are not in "Used" column?

&nbsp;
&nbsp;

mrhussam · Answer

I need to know the locations not bean use in (used)

mrhussam · Answer

Not been used*

Forum Discussion

If and vloockup

6 Replies