need help with vlookup function

[vikkam]

I am preparing a spread sheet for calculating payplan for dealership
service advisors.

i have attached payplan in word and my spread sheet.
i need help with vlookup function to look up %ages from the tabl
either in annual sheet or monthly sheet.

I have had great help from thi sforum every time i approached.

thanks much

vikkam:confused

+-------------------------------------------------------------------
|Filename: SERVICE ADVISOR PAY PLAN.zip
|Download: http://www.excelforum.com/attachment.php?postid=4312
+-------------------------------------------------------------------

 

[swatsp0p]

Hi, Vikkam. I really don't need to look at your sheet (I won't open
files here for safety reasons), but please give a better description of
the problem you are having. Vlookup is pretty straightforward.

=VLOOKUP(WHAT VALUE TO LOOK FOR,WHERE IS THE DATA TABLE, COLUMN TO
RETURN;EXACT MATCH OR CLOSEST VALUE IF NO MATCH)

e.g. =VLOOKUP(A1,B112,3,0) will look for the value in A1 in the
range B1:B12. If found it will return the value in the corresponding
row in Column D. If not found, #N/A will be returned.

 

[vikkam]

Bruce
Thanks fo rprompt response. I am still lost and confused.

I tried but I keep on getting ref or some other non numerical value.

I will appreciate if you can have a look at file and tell me what I am
doing wrong.

Thanks once again

confused.

 

[vikkam]

For those who are not keen to open attachment, i am reproducing the
formuale and table.

I tried follwing formulae
=VLOOKUP(H22,$K$52:$M$56,3,0)
repeating k52:m56 below
0 99,999.00 3 %
100,000.00 119,999.00 3.25 %
120,000.00 139,999.00 3.70 %
140,000.00 149,999.00 4.00 %
150,000.00 4.25 %

If the value of h22 is as per first column and then I get correct %.
For any thing else I get error message.

thanks much in anticipation

 

[Dave Peterson]

That 4th parm (0 or false) tells the formula that you want an exact match to be
found.

Try
=VLOOKUP(H22,$K$52:$M$56,3,true)

 

[swatsp0p]

Dave is correct. As I listed in my example, use of zero as the 4th
parameter will return an error if the exact lookup value is not found
in the first column of the lookup table.

Thanks, Dave.

Bruce

 

[vikkam]

thanks much

vikkam