On Sun, 26 Mar 2006 19:39:04 -0600, sharkfoot
<sharkfoot.25b1om_1143423601.1148@excelforum-nospam.com> wrote:

>
>Ron Rosenfeld Wrote:
>>
>>
>> What are the rules for populating these cells?
>>
>> You might be able to use one of the lookup functions.
>> --ron
>
>Let's see. If O5 is equal to any one of 9 possible options (text
>options), then O6:O11 would have to recognize that and know which sheet
>to pull the interest rate from.
>
>O4 will always be a number between 350 and 850 (user defined)
>C7 will always be a number between 1985 and 2007 (user defined)(drop
>down menu)
>C8 will be one of 129 different possibilities (user defined)(drop down
>menu)
>O5 will be one of 9 possible lending institutions (user defined)(drop
>down menu).
>
>So from what the user enters in O4 and then selects from the other 3
>drop down menus, the interest rate and term will have to be recognized.
>So I need O6 to equal a certain interest rate based o which bank was
>chosen, which credit score was entered, the year and model of the
>vehicle they are buying. O7 will have to recognize the same thing and
>return the term based upon the vehicle they are buying. Then O8:O11
>will also figure the rate and terms based upon those 4 cells and give
>the buyer multiple payment options. So there will be many many
>possibilities based upon those 4 user defined cells.
>
>I just need to know how to make O6, O7, O9, O10, O12 and O13 smart
>enough to filter all 4 of the user defined cells and return the
>appropriate values. Each of the possible lenders has their own sheet,
>each sheet has entries for interest rates and terms based upon credit
>scores and they are all compiled in a table format of sorts, although
>no two lender sheets are identical.
>
>So I guess I need O6 to look at O5, see what bank it is and then goto
>that bank's sheet, then look at C8 and detrmine the vehicle so it knows
>which row to look on for the interest rate, of which it detrmines by the
>credit score entered into O4. Then whatever column it is in, it would
>know to grab the term from there and the payment would be figured.
>
>Now I wonder if I made sense at all.

It's not clear enough to come up with a solution, but it sounds like my
original suggestion of using lookup tables is what you need to do. Obviously
you will need multiple tables to handle your problem.


--ron