Small if+and

Hi Guys,

A bunch of you just helped me out with a small formula. Thanks!!
I was wondering If I could expand that fomula with an "and".

Here is what I was given:

Please Login or Register  to view this content.

If was wondering if I could make it so that before returning a value, the formula would exclude contents in column f that ="be waiting".

I was trying the below, but kept getting a #num error??

Please Login or Register  to view this content.

Thanks a million

Typically you can't use AND in these type of formulas because it returns a single result rather than an array. Try like this

=SMALL(IF('PASTE HERE'!C2:C300="amc",IF('PASTE HERE'!F2:F300<>"be waiting",'PASTE HERE'!K2:K300)),2)

confirmed with CTRL+SHIFT+ENTER