Try this:

=IF(F11<=SMALL($F$5:$F$17,2),"",IF(B11<"",VLOOKUP (B11,$J$2:$Q$6,7,FALSE),""))

--
Biff
Microsoft Excel MVP


"JBoyer" wrote in message
...
=IF(F11=MIN($F$5:$F$17),"",IF(B11<"",VLOOKUP(B11, $J$2:$Q$6,7,FALSE),""))

I'm currently using this formula to check which one is the lowest value
and
if it is make it "".

It works fine but I'd like to check for the lowest 2, so I want if to make
it "" if it is min OR second lowest, but i dont know a function to find
the
second lowest value in a set of numbers.

Thanks in advance for any help!