K
Katja.Buckley
=HLOOKUP(B7,'Building Details'!$A$2:$R$24,MATCH(B11,'Building
Details'!
$A$2:$R$2,0))
This is in response to yesterday's posting. At least the formula
works, however, it returns a "True" statement instead of what I want
it to return which is the Commission percentage.
Maybe Match is not what I need to use?
Again, what I am trying to do is, give me is if
A B C D
Building Name |Expansion | New |Renewal
Home | 5 | 6 | 7
Office | 4 | 5 | 6
That if dropdown B7 selected home and drop down B11 selected
Expansion
then the field B 20 holding the above formula automatically populates
it with 5
Details'!
$A$2:$R$2,0))
This is in response to yesterday's posting. At least the formula
works, however, it returns a "True" statement instead of what I want
it to return which is the Commission percentage.
Maybe Match is not what I need to use?
Again, what I am trying to do is, give me is if
A B C D
Building Name |Expansion | New |Renewal
Home | 5 | 6 | 7
Office | 4 | 5 | 6
That if dropdown B7 selected home and drop down B11 selected
Expansion
then the field B 20 holding the above formula automatically populates
it with 5