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