TABLES...

  • Thread starter Thread starter trey
  • Start date Start date
T

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
 
Hi Trey!

Build your data table.

=VLOOKUP(A1,MATRIX!A2:D7,MATCH(B1,MATRIX!A1:D1,0))

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

Biff
 
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
 
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
 
Back
Top