Add an "OR" to a nested if, vlookup and concatenate

[HuskyJones]

Please help my broken brain again.....

I've got this formula that works perfectly...... (I know it might be longer than you superdoops do)

=IF('CDS Data'!BY241="",IF('CDS Data'!$BW241<>"",VLOOKUP('CDS Data'!$BW241,'Look Up Tables'!$T$2:$W$40,1,FALSE),CONCATENATE($Z242,"|",$O242,"|",$P242)),CONCATENATE('CDS Data'!$BW241,"|",'CDS Data'!BY241,"|",$Z242,"|",$O242,"|",$P242))

I now want to say
IF('CDS Data'!BY241="" OR 'CDS Data'AM241="120" ......
So basically if BY241 is blank or AM 241 says 120 then if BW241 isn't blank vlookup blah-de-blah and if it is blank then concatenate these ones

(Thank you for the concatenate the other day! it works a treat!)


FANKOOOOOO

 

[Special-K99]

Try

=IF(OR('CDS Data'!BY241="",'CDS Data'!AM241=120),IF('CDS Data'!$BW241<>"",VLOOKUP('CDS Data'!$BW241,'Look Up Tables'!$T$2:$W$40,1,FALSE),CONCATENATE($Z242,"|",$O242,"|",$P242)),CONCATENATE('CDS Data'!$BW241,"|",'CDS Data'!BY241,"|",$Z242,"|",$O242,"|",$P242))

 

[HuskyJones]

"Flippin' 'eck", why didn't that work when I tried it
Many thanks!