need urgent help: completely lost/stuck with vlookup issue

Originally Posted by jimmyjj

I'm in a computer class and learning excel and have been trying to figure out this last step for my assignment for the last 3 hours and am about to give up. Here is the file.. http://members.cox.net/cakemix/6.xls

The question is.. The witholdings tax in cell I2 is based on the taxable pay and the tax table. Use a VLOOKUP function to determine the tax rate, then multiplty by the taxable pay.

I have tried every possible way to make it work, and cant seem to get it done. Could someone please explain how to do this to me? My textbook is of no help, neither is anything I have been able to Google.

Thanks so much for any and all help.

To lookup the rate

=VLookup( what, where, column of data, true)

=VLookup(H2,G13:H17,2,True)

that times the tax =

=H2*VLookup(H2,G13:H17,2,True)

hth
---