Quote:
Originally Posted by Claus Busch
Hi,
modify the range and the column in the formula to your table:
=IF(OR(COUNTIF(Status!A:A,A2)=0,COUNT(FIND({"End of Life";"Delete"},VLOOKUP(A2,Status!A2:D100,4,0)))0 ),"N","Y")
Regards
Claus B.
--
Windows10
Office 2016
|
Claus,
Thanks once again for the speedy solution to my excel dilemma.
Any recommendations for training resources that will allow me to understand / write formulas like this. I have a basic understanding of the more common formulas but have trouble putting together the more complex ones.
Regards
Nuruddin