Lookup criteria formula required

[Guest]

Help needed please.

A B C
1 1% 2.50% 3%
2
3 1.25%

I need a lookup formula that will look at A3,(1.25%)
and return the value in A1,(1%).
The value in A3 is variable and would be anything from 1%
to 3% in .1 increments,(in this example).If the value in
A3 was 2.73% i would like it to return B1,(2.50%)

An ideal formula would be lookup A3 and whatever value is
in that cell return the value in row A1:C1 that is the
nearest value rounded down.

Hope that makes sense.

 

[Peo Sjoblom]

=INDEX(A1:C1,MATCH(A3,A1:C1))

 

[Bob Phillips]

How about this

=INDEX(A1:C1,ROW(A1)*MATCH(A3,A1:C1,1))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Frank Kabel]

Hi
try
=HLOOKUP(A3,A1:C1,1,1)

HTH
Frank