Formula returns some false values and criteria not specified in formula.

[Don Black]

Hello All-

While the below formula does work it is picking up data not specified by the set criteria. I only want the data specified by the set criteria to be referenced. I want to skip any cell where the conditions are not met and return the cells where all criteria has been met.

=IF(OR('WO-SO'!$H2444="MH",'WO-SO'!$H2444="ROAD TRIP",'WO-SO'!W2444="test",'WO-SO'!W2444="CUSTOMER"),IF('WO-SO'!A2444="","",'WO-SO'!A2444))

I am still a newbie please forgive proper syntax terminology.

 

[NARAYANK991]

Hi Don ,

Since the formula is not giving you the results you expect , how can we know what you want by looking at the formula ?

If you can list down the criteria which you want to be applied , it will be easier to suggest the correct formula.

Narayan

 

[Don Black]

https://drive.google.com/open?id=0By3hrK3o8_Z4X2lfQVhZS1lvczQ&authuser=0 Here please look at workbook

 

[Don Black]

I fixed it simple syntax mistakes.