Hi
sorry, my fault. Use
=VLOOKUP(9.9999999E307,$X5:$X100,1)

--
Regards
Frank Kabel
Frankfurt, Germany

Hi Frank,

I tried the VLOOKUP formula below but it's telling me that I've
entered too few arguments.

Thanks,
Nan


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