Complicated Vlookup and array

[cmatni]

Hi I have a table with the columns pay and Federal Tax and I have t
look for the right federal tax in another table where there is a range
for example

Pay************* Federal Tax
2450**************** ?*
2457******************?
343******************** ?

Another Table

pay range******* Tax rate

0-799************** 8%
800-999*********** 1%
1000-1499*********15%
1500 +**************20%


I created another table to help me putting the lowest range


0************** 8%
800*********** 1%
1000*********15%
1500**********20%

And i Have to use vlookup, any ideas how to do this ?

Thank

 

[Claus Busch]

Hi,

Am Mon, 15 Oct 2012 16:23:54 +0000 schrieb cmatni:

Pay************* Federal Tax
2450**************** ?*
2457******************?
343******************** ?

the table above in A1:B4

0************** 8%
800*********** 1%
1000*********15%
1500**********20%

the table above in G1:H4
Then try:
=VLOOKUP(A2,$G$1:$H$4,2,1)


Regards
Claus Busch