Vlookup Function Help

[babyworm]

Hi,
I have a condition range like this:
300 <=worker salary<=500 then tax taken 2%
500 <worker salary<=1000 then tax taken 5%
1000 <worker salary<=1500 then tax taken 10%
....

I know I can't use IF because it has many conditions (more than 1
ones). I remember Vlookup can do this but now I don't remember it.
look the online help but no result.

Anybody knows how to solve this, pls help me.

Any help is very appriciated.

Thanks,
Babywor

 

[Andy B]

Hi

You need to set up the break points in a table:
300 .02
500 .05
1000 .1
.. . . . .

Then you can use:
=VLOOKUP(A1,A2:B14,2)
with your value in A1 and your table in A2:B14