=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!

Check out the Small() function.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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!

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!