say i have a range of name called Red_Fruit, Blue_Fruit
and i have a box to input the color of a fruit
I want to be able to select a list of fruit based on the color chosen
How would i call back the name if only part of the name changes?
say i have a range of name called Red_Fruit, Blue_Fruit
and i have a box to input the color of a fruit
I want to be able to select a list of fruit based on the color chosen
How would i call back the name if only part of the name changes?
Last edited by d0n; 06-09-2009 at 01:39 PM.
Maybe?
=Indirect(A1&"_fruit")
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
it seemed to work but for some reason its not, i have this so far (attached)
Are you trying to create a new drop down list or just list the results in A2, downwards.
just list the results based on color i pick
Try, in A2:
=IFERROR(INDEX(INDIRECT($A$1&"_Fruit"),ROWS($A$1:$A1),COLUMNS($A$1:A$1)),"")
copied down and over to next column...
Got it thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks