View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vikkam
 
Posts: n/a
Default vlookup function


I need help with vlookup function.

I need the formulae to look up csi in f22 and in table u22-v29 and
return the figure in s column corrosponding to value in f22.
In example if it is 80 % the value in g22 will be 0.75 %
if the value is 50 % g22 wll be -1.00 %

Thanks much

vikkam


+-------------------------------------------------------------------+
|Filename: sc_payplan_svcwrtr_120805.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4107 |
+-------------------------------------------------------------------+

--
vikkam
------------------------------------------------------------------------
vikkam's Profile: http://www.excelforum.com/member.php...fo&userid=1266
View this thread: http://www.excelforum.com/showthread...hreadid=492063