| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using functions to compare multiple columns for mismatch of cells | Excel Worksheet Functions | |||
| lookup and choose wih multiple tables of unequal column lengths | Excel Discussion (Misc queries) | |||
| Multiple criteria LOOKUP | Excel Worksheet Functions | |||
| VLookup on multiple columns | Excel Discussion (Misc queries) | |||
| Convert multiple columns to rows | Excel Worksheet Functions | |||
Threaded Mode
