If and vloockup

Copper Contributor
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.
6 Replies

@Mrhussam 

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

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 

 

@Sergei Baklan 

@Mrhussam 

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

image.png

 

 

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

@Mrhussam 

That could be

=SORT(FILTER(A2:A8000,(COUNTIF(D2:D8000,A2:A8000)=0)*(A2:A8000<>"")))