Hi
try the formula. It should work as I use VLOOKUP without FALSE as 4th
parameter. So VLOOKUP will return the value <= the lookup value

--
Regards
Frank Kabel
Frankfurt, Germany

"natei6 " schrieb im
Newsbeitrag ...
Hi Frank,

Thanks for the response, but I'm not sure how that will work with the
different criteria at the beginning and end of the formula, ("=If
(A1<=5,"15.000" )at the beginning and (=If(A1=16,"49.000") at the
end.

Thanks Again

Nathan Sargeant


---
Message posted from http://www.ExcelForum.com/