View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default And new Pay Rates


Question - why does your formual use the INDIRECT function??

why not just:

=IF(C7="",0,VLOOKUP(C7,EmployeeList,2, 0))

just curious!
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=494989