Hi I have a table with the columns pay and Federal Tax and I have to 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 ?

Thanks

Hello,

You need to use the Vector Form of the Lookup function. The argument of this function would be as following.
Lookup Value - Amount from your first list
Lookup Vector - First Column in your third list
Result Vector - Second Column in your third list

I tried and it was working fine at my system. Please let me know if this doesn't work for you.

To understand how LOOKUP function work check the Excel Documentation or reply to me and I will be happy to explain.

Please let me know if this was helpful to you.

Thank You,
Prashant

Thanks !! it worked

You are welcome.

Let me know for any Excel/VBA related issues.

Thank You,
Prashant

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2