TABLES...

[trey]

TYPE
1% or 1mo Int x 1YR OR x2YR OR 3YR ( IM NOT MULTIPLYING )
2% or 2mo Int
3% or 3mo Int
4% or 4mo Int
5% or 6mo Int
3-2-1%
5-4-3%

I HAVE A VALIDATED LIST - DROP DOWN WITH 7 CHOICE'S - AND
ANOTHER LIST OF 3 CHOICES ( 1,2 & 3 ) AND I NEED TO KNOW
WHAT KIND OF FORUMULA I NEED TO USE....
EX: WHEN YOU CHOOSE 5% OR 6mo Int to 3YRS =20
THANKS
TREY

 

[Biff]

Hi Trey!

Build your data table.

=VLOOKUP(A1,MATRIX!A27,MATCH(B1,MATRIX!A11,0))

Make sure the names match!!!!!!!!!!!!!!!

Biff

 

[TREY]

HEY WHATS UP..IVE TAKEN THAT TABLE AND PUT IT ON ANOTHER
WORKSHEET... THIS IS WHAT IT LOOKS LIKE...
Type 1yr 2yrs 3yrs A B C
1% or 1mo Int 1 2 3 +40 +30 +20
2% or 2mo Int 1 2 3 +35 +25 +10
3% or 3mo Int 1 2 3 +30 +15 +0
4% or 4mo Int 1 2 3 +25 +10 -10
5% or 6mo Int 1 2 3 +20 +0 -20
3-2-1% 1 2 3 +30 +20 +10
5-4-3% 1 2 3 +20 +5 -15

EX: CLICK ON 5% OR 6 MONTH FOR 3yrs = -20 IN COLUMN "C"

IM TRYING TO DO A DROP DOWN MENU FOR THE TYPE AND THEN
YRS TO GIVE ME THE AMOUNT IN ANOTHER CELL...
BY THE WAY THE PREQUAL IS WORKING GREAT...THANKS AGAIN
BIFF FOR THE HELP...
TREY

 

[Biff]

Well, if that's how you want the table, then adapt this
formula:

C1 = dropdown for TYPE
D1 = dropdown for YRS

Formula:

=VLOOKUP(C1,C3:I9,D1+4,0)

Don't ya just love this stuff!

Biff