return a value from a range

[Tom]

Hi all,
I have a column of numbers in D3:D25 and corresponding values in E3:E25.
When I enter a value into A3, I would like B3 to return the value that
corresponds to column D where it's value is NOT higher than A3. For example:
If A3=22.3...and column D numbers are 21.5,22.5,23.5, I would like to return
the value next to the cell with the 22.5. Things sure are difficult to
explain in text sometimes!!!

Thanks in advance!

[Bob Phillips]

=INDEX(E3:E25,MATCH(A3,D3:D25,1))

your explanation conflicts with the example. The value Not higher than 22.3
is 21 not 22.5

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tom" <[email protected]> wrote in message
news:[email protected]...
> Hi all,
> I have a column of numbers in D3:D25 and corresponding values in E3:E25.
> When I enter a value into A3, I would like B3 to return the value that
> corresponds to column D where it's value is NOT higher than A3. For
example:
> If A3=22.3...and column D numbers are 21.5,22.5,23.5, I would like to
return
> the value next to the cell with the 22.5. Things sure are difficult to
> explain in text sometimes!!!
>
> Thanks in advance!

[Tom]

Hi Bob, I may have goofed on the explanation...but you got exactly what I was
looking for.

Thanks!!!

"Bob Phillips" wrote:

> =INDEX(E3:E25,MATCH(A3,D3:D25,1))
>
> your explanation conflicts with the example. The value Not higher than 22.3
> is 21 not 22.5
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Tom" <[email protected]> wrote in message
> news:[email protected]...
> > Hi all,
> > I have a column of numbers in D3:D25 and corresponding values in E3:E25.
> > When I enter a value into A3, I would like B3 to return the value that
> > corresponds to column D where it's value is NOT higher than A3. For
> example:
> > If A3=22.3...and column D numbers are 21.5,22.5,23.5, I would like to
> return
> > the value next to the cell with the 22.5. Things sure are difficult to
> > explain in text sometimes!!!
> >
> > Thanks in advance!
>
>
>