Worked like a charm! Thank You!
Wayne

"Wayne G. Dengel" wrote in message
news:V3gjd.2181$bH2.536@trnddc09...
I need means to locate the nearest nbr in column of nbrs that is GREATER
than the source nbr. (Did I say that right?) VLOOKUP finds the nearest
LOWEST.

nbr in question: 6.2
list of nbrs:
4.2
5.6
7.9
10.4
13.5
15.0

Entering 6.2, I would like to find 7.9 (NOT 5.6). Please how do I do
this?

I am not experienced at Visual Basic, thus please need a detailed answer.

Thank You!

Wayne