Looking for a number in Range

[ionelz]

This is like tax question.
If Salary A1 < C1 then D1
If Salary A1 is between C1 and C2 then D2
....
If A1=90234 then at B2 I sould get D3=20

Range C1:D6
C1= 60000 D1=10
C2= 90000 D2=16
C3= 123000 D3=20
C4= 162000 D4=24

[mehmetcik]

Your Question makes no sense.

What is B1 and what is B2?

And If A1 is < B1 why are we even talking about D1 to D4

[ionelz]

Yes, sorry, corrected...

[mehmetcik]

You should use a formula like

=LOOKUP(A1,{0,60000,90000,123000,162000},{0,10,20,30,40,40})

then you do not need to use a table.

[ionelz]

Thanks
I would like to be able to change in range C1:D4, not in formula

[José Augusto]

Try
=LOOKUP(A1,C1:C4,D1:D4)

[ionelz]

I get D2 (not D3), so I get the more close value

[José Augusto]

Hi

First value must be 0, i.e. C1=0 ; D1=10, ...

You can use another formula

Please Login or Register  to view this content.

See the file