Vlookup Function Help

  • Thread starter Thread starter babyworm
  • Start date Start date
B

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