Return cell if one cell contains and second is the Max

[RichardLee]

I have a table of Data and would like to identify certain items.

this must be if a description contains '*VF*' and the second column is the Max number above '2' it must return the "Text"

Order No	Layer	Composite	Text
103902(1)	1	TEI30/18-2 VI	4mm Clear Tough
103902(1)	2	TEI30/18-2 VI	3mm Gel
103902(1)	3	TEI30/18-2 VI	4mm Barrier Glass Toughened
103902(1)	4	TEI30/18-2 VI	3mm Gel
103902(1)	5	TEI30/18-2 VI	4mm Clear Tough
103902(1)	6	TEI30/18-2 VI	12mm Black Spacer - 26mm Duplex RAL9005
103902(1)	6	TEI30/18-2 VI	12mm Black Warm Edge Spacer
103902(1)	7	TEI30/18-2 VI	6mm Toughened Low E KS
103908(1)	1	TEI60/26-2	5mm Clear Tough
103908(1)	2	TEI60/26-2	5mm Gel
103908(1)	3	TEI60/26-2	6mm Barrier Glass Toughened
103908(1)	4	TEI60/26-2	5mm Gel
103908(1)	5	TEI60/26-2	5mm Clear Tough
103912(1)	1	TEI30/18-2	4mm Clear Tough
103912(1)	1	TEI60/25-3	4mm Clear Tough

[Aditya_Chitale]

is this what you wanted ?

if(num(Layer)>2 and wildmatch(description ,'*VF*'),Text,null())

Regards,

Aditya