your min formula will ignore blank cells so wrap your vlookup formulas
something like this
=IF(ISNA(VLOOKUP(F25,D25:E27,2,FALSE)),"",VLOOKUP( F25,D25:E27,2,FALSE))

--
paul

remove nospam for email addy!



"martin" wrote:


I need to find the lower number of three numbers but I have a N/A error in
two sometimes due to a vlookup formula. Is their away of ignoreing n/a ERROR
??