Try something like this:

Put this table of values in A1:C6
198 208 2.0
209 219 2.5
220 229 3.0
230 240 3.5
241 247 4.0
248 258 4.5

Next....
put this formula in F1
=VLOOKUP(E1,$A$1:$C$6,3,1)
(it will initially display #N/A)

Last...enter a number in E1...The formula in F1 will assign it a value.

Example:
E1: 215
F1: displays 2.5

Is that something you can work with?
Post back with any questions.
***********
Regards,
Ron

XL2002, WinXP


"Helene deChappe" wrote:

I'm dong a random giveaway and have a huge list of name in an excel sheet. Is
there a way for excel to pick a random cell instead of printing, cutting and
pulling from a hat. I thought I did this ions ago but maybe it was a dream???