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