Forum Discussion
Pull in a picture
kdwork I believe you'll find the answer to your question here
This is not quite working for me. (See attachment) I added each brands logo and name. Cell A19 (AMERICAS) is populated from another cell in another worksheet (='NEW OFFICE COPY'!Z10). I added a list for cell A19, but because it is autopopulated, for my list (and logo names) I have to use the same name as what is pulled in (ie. can't use zAMERICAS for the logo name and List name). When I change the "brands" being used that autopopluates, the dropdown list changes to match, so that part is working ok. I think the problem is that I already have the "brand" names in the Name Manager, so when I type =LOGOS in the formula bar to link the indirect formula, it is pulling in the information of the other Americas value instead of the logo. When I change the "brand", it changes the values to the other associated name. Is there a way if I were to use an alternate name (i.e. zAmericas) for the logos to somehow associate it with Americas so when the that is pulled in, it would look to zAmericas for the logo?
kdwork It's always difficult to diagnose a problem from a picture alone, but I suspect that the problem lies in the way you call for local (worksheet) named ranges vs. global (workbook) named ranges.
The first named range "americas" has a local scope in the LOGOS worksheet. If you want to call it from any other worksheet, you need to refer to it as "LOGOS!americas". Just calling for "americas" will automatically refer to the globally defined range/formula with that name, if a local one does not exist within the sheet it is called from. The link below has more insights on how this works and refers to a tool developed by (among others) JKPieterse. Perhaps his tool or he himself (active in this community) can help you resolve your problem, in case my general comments above could not.
https://exceljet.net/named-ranges (scroll all the way down for named ranges and scope)
- I would suggest to download my Name Manager and make sure the names are properly scoped. AT least make sure there aren't duplicate local and globally scoped names as that highly confuses the matter. https://jkp-ads.com/officemarketplacenm-en.asp. ALso, have a look at this article: https://jkp-ads.com/Articles/ShowPicture00.asp
