View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sharkfoot
 
Posts: n/a
Default Lookup tables with multiple columns


I have a table that stretches from A1:X45 and every cell has a different
interest rate in it. Do I use lookup tables to identify the rates from
my data entry sheet? I need to find the appropriate value both
horizontally and vertically so I don't know how to approach this?
Thanks!


--
sharkfoot
------------------------------------------------------------------------
sharkfoot's Profile: http://www.excelforum.com/member.php...o&userid=32164
View this thread: http://www.excelforum.com/showthread...hreadid=526951