About Us

b_nuruddin

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

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
INDEX MATCH Functions in LibreCalc (Excel) - Non unique valuesreturn wrong index result	io	Excel Worksheet Functions	0	February 23rd 13 09:08 AM
index(match) Wind Uplift Calculations (match four conditions)	JMeier	Excel Worksheet Functions	8	August 1st 08 01:45 AM
index-match and another condition	need a help[_2_]	Excel Discussion (Misc queries)	6	July 23rd 08 11:22 PM
index match array function-returning only first match, need last.	Julie Olsen	Excel Worksheet Functions	3	December 29th 06 12:50 AM
index,match,match on un-sorted data	Brisbane Rob	Excel Worksheet Functions	3	September 24th 05 10:04 PM

Menu

About Us