Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine HLOOKUP and MATCH
Hi again,
Step two in my crazy worksheet The following function returns a N/A =HLOOKUP(B7,'Building Details'!$A$2:$R$24,MATCH(B11,'Building Details'! $A$2:$R$2,0)) What I am trying to accomplish is Excel to put in the number that it finds when crossreferencing B7 and B11 E.G. B7 = Building Name B11=Type of Lease Based upon the Type of Lease the commission amount differs so, for example if Building A has a Renewal then the commission is 5% and the 5% are supposed to go in the field where I plucked the above listed formula. Thanks so much!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup and Hlookup Combine? | Excel Worksheet Functions | |||
Can you combine VLOOKUP with a nest HLOOKUP? | Excel Discussion (Misc queries) | |||
Combine Vlookup and Hlookup | Excel Worksheet Functions | |||
Do I need to combine hlookup and countif????? | Excel Worksheet Functions | |||
When MATCH and v/hLOOKUP functions *FAIL* to match (but they should)... | Excel Worksheet Functions |