Rlb53
04-21-2012, 07:41 PM
Hello All....
I have a Table with a series of "Range Names" listed in each.
Depending upon the value returned in an adjacent cell I'm asking the formula to Vlookup the left column of Table1 and find the value(which designates a range). Then Match the Row (again through the Vlookup) with the associated column with a Header Value that has been selected (once again with the use of Vlookup).
The formula I've generated is as follows:
=INDEX(VLOOKUP(E23,Table1,2,FALSE),MATCH(E35,VLOOKUP(E23,Table1,3,FALSE),1) ,MATCH(100,VLOOKUP(E23,Table1,4,FALSE),0))*E28
If I plug in the range names directly into the formula it works:
=INDEX(Table1,MATCH(E35,Range1LeftColumnRange,0),MATCH(100,Range1HeaderRang e,0))*E28
The Table looks like this:
Table1
---------------Header1 -----------Header2------------------------- Header3
1 -------------Range1---- Range1LeftColumnRange -------Range1HeaderRange
2 -------------Range2---- Range2LeftColumnRange------- Range2HeaderRange
etc.
Is there some Syntax that I need to add to get the formula to recognize the values listed in Table1 as Range Names during the Vlookup?
Thanks
I have a Table with a series of "Range Names" listed in each.
Depending upon the value returned in an adjacent cell I'm asking the formula to Vlookup the left column of Table1 and find the value(which designates a range). Then Match the Row (again through the Vlookup) with the associated column with a Header Value that has been selected (once again with the use of Vlookup).
The formula I've generated is as follows:
=INDEX(VLOOKUP(E23,Table1,2,FALSE),MATCH(E35,VLOOKUP(E23,Table1,3,FALSE),1) ,MATCH(100,VLOOKUP(E23,Table1,4,FALSE),0))*E28
If I plug in the range names directly into the formula it works:
=INDEX(Table1,MATCH(E35,Range1LeftColumnRange,0),MATCH(100,Range1HeaderRang e,0))*E28
The Table looks like this:
Table1
---------------Header1 -----------Header2------------------------- Header3
1 -------------Range1---- Range1LeftColumnRange -------Range1HeaderRange
2 -------------Range2---- Range2LeftColumnRange------- Range2HeaderRange
etc.
Is there some Syntax that I need to add to get the formula to recognize the values listed in Table1 as Range Names during the Vlookup?
Thanks