I have the following table on worksheet 3
A | B | C | D
1 Building Name | Renewal | Expansion | New
2 House | 6 | 3 | 6
3 Office | 5 | 5 | 7
On my worksheet 1, I have two dropdown boxes: B7 (that gives the building name) and B11 which gives the Type of Commission (Renewal, Expansion, New)
B 20 is supposed to automatically select the percentage based upon what B7 and B11 select. E.g. B7 = House, B11 = Expansion then B20 should be 3.
This is my formula.
=HLOOKUP(B7,'Building Details'!$A$2:$R$24,MATCH(B11,'Building
Details'!$A$2:$R$2,0))
Thanks
Bookmarks