The third argument in the VLOOKUP is the offset column, so if you have a way
you can determine which column to extract the from when it finds a matching
value it doesn't matter how many columns in your lookup table, excluding the
actual limit of 256.

VLOOKUP(Lookup_Value, Lookup_Table_Location,Return_Value_Column)


--
Kevin Backmann


"sharkfoot" wrote:


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