Hi,

I want to report the 2 smallest numbers from a list of conditions, however small() does not allow me to write if() conditions inside...

=SMALL({IF(AND(ISNUMBER(SEARCH("AT";L5));VLOOKUP("AT";Tableinput;4;FALSE)<=100);VLOOKUP("AT";Tableinput;;FALSE);0);IF(AND(ISNUMBER(SEARCH("GR";L5));VLOOKUP("GR";Tableinput;4;FALSE)<=100);VLOOKUP("GR";Tableinput;5;FALSE);0);IF(AND(ISNUMBER(SEARCH("RO";L5));VLOOKUP("RO";Tableinput;4;FALSE)<=100);VLOOKUP("RO";Tableinput;5;FALSE);0)};2)
Thanks a lot for your help, I am getting crazy with this!