Dropdown selection crashes
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)) |
All times are GMT +1. The time now is 02:05 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com