I have a dropdown list generated by validation function that is used
in the formula below. When user makes a selection in cell I$5,
formula was supposed to lookup the appropriate flexible ranges to come
up with the value.
For some reason only the first name on my list works. When I pick any
other name from that list, I get #Ref error. It seems like excel has
it programed somewhere that this is the only name allowable. I've
tried renaming my choices but it didn't fix the problem. Only that one
name works. Any suggestions on fixing the problem? Thanks.

INDEX(INDIRECT(VLOOKUP(I$493,INDIRECT(VLOOKUP(I$4, Range_1,2,FALSE)),3,FALSE)),MATCH(I$5,INDIRECT(VLO OKUP(I$4,Range_1,4,FALSE)),0),MATCH(MONTH($A5),MON THS_3,0))

Hi
this is probably a formula error. Difficult to say without knowing what
each element returns. If you like email me an example file and I'll
have a look at it

--
Regards
Frank Kabel
Frankfurt, Germany

"Kate Smith" schrieb im Newsbeitrag
om...
I have a dropdown list generated by validation function that is used
in the formula below. When user makes a selection in cell I$5,
formula was supposed to lookup the appropriate flexible ranges to
come
up with the value.
For some reason only the first name on my list works. When I pick any
other name from that list, I get #Ref error. It seems like excel has
it programed somewhere that this is the only name allowable. I've
tried renaming my choices but it didn't fix the problem. Only that
one
name works. Any suggestions on fixing the problem? Thanks.


INDEX(INDIRECT(VLOOKUP(I$493,INDIRECT(VLOOKUP(I$4, Range_1,2,FALSE)),3,F
ALSE)),MATCH(I$5,INDIRECT(VLOOKUP(I$4,Range_1,4,FA LSE)),0),MATCH(MONTH(
$A5),MONTHS_3,0))