Hi
do you want the value from column a or B returned?
for volumn A:
=VLOOKUP(1.3,A1:B20,1,TRUE)

for column B:
=VLOOKUP(1.3,A1:B20,2,TRUE)

Assumption: your data is sorted ascending in column A


--
Regards
Frank Kabel
Frankfurt, Germany


PeterG wrote:
Hi all,

I need a little help with a formula - if it can be done ...
Below is a table that shows kw units and cost. A calculation is
performed on information user supplies and the result can be anywhere
between 0.0 and 3.
If for instance the result returns 1.3, can I get a formula to check
is
1.3 is there and if not select the next nearest 1 higher ie 1.5


A B
0.5 51
0.75 51
1 62
1.25 62
1.5 63
2 63
2.25 63
2.5 64
3 64