Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I create a lookup using layered parameters
I am attempting to setup a calculator which will calculate property value
based on loan amounts using the equation: PV = LA/max % financed. The problem is % is based off many factors. I have the loan tables setup with all the possible percents based on loan amount. This information is housed on a separate worksheet in the same file. I am having trouble finding the right lookup funtion to first look for the right table and then find the right percent to use from the table based on loan amount. There are 36 different tables based on property and loan type. I need the function to find the right table to go to based on information entered by the user then pluck the right percent for LA to input into the equation to calculate PV. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup by multiple parameters | Excel Worksheet Functions | |||
How do I create meta-layered spreadsheet | Excel Discussion (Misc queries) | |||
Layered charts | Charts and Charting in Excel | |||
How do I create a graph displaying two parameters for one item | Charts and Charting in Excel | |||
Layered "If" statement. | Excel Worksheet Functions |