Lookup criteria formula required

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)
 
Back
Top