I have been looking for a formula that would only return values where the criteria was met.
Skipping any other cells where the statement was not true. It will also be referencing a different worksheet.
I started out with a Vlookup which did not give me what I needed.
Then I used the "ISERROR" function but still did not get the information I needed.
IF(ISERROR(SMALL('WO-SO'!C2571:C3147,ROW()-2)),"",SMALL('WO-SO'!C2571:C3147,ROW()-2))
Skipping any other cells where the statement was not true. It will also be referencing a different worksheet.
I started out with a Vlookup which did not give me what I needed.
Then I used the "ISERROR" function but still did not get the information I needed.
IF(ISERROR(SMALL('WO-SO'!C2571:C3147,ROW()-2)),"",SMALL('WO-SO'!C2571:C3147,ROW()-2))