Please can anyone help with this.
I need to be able to extract information from a named range. As per picture, which works.
However, the pre-requisites are:-
(1) The name of the range is in a cell and the name of the range must feature in the solution
(2) Must get rid of the indirect function and slowing my spreadsheet.
See attached. Please note this is an example not the proper use, which is too complicated to put on here.
Any suggestions please?
Thanks.
screen_capture.JPG
Your only other options, formula wise, would be to use a CHOOSE construct - and pending no. of ranges that may not prove sensible...
Using your above, much simplified, example:
=INDEX(CHOOSE(MATCH(C6,{"Fruit","Cars","Materials","Size"},0),Fruit,Cars,Materials,Size),3,1)
edit: of course, in the simplified example shown you would just use INDEX/MATCH.
Last edited by XLent; 10-16-2019 at 07:59 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks