Forum Discussion
Challenge 5
mathetes
Dear in attachments you can find the Excel file
With reference to the video referred to by JMB17, please find some additional comments below.
The key feature is that you have to create Named Ranges and indirectly reference them by a Named Formulae. Now, the video deals with one picture (a flag) that gets displayed based on a selection from a drop-down. You could do something similar for each of the items in your output range in column K based on the Item code in column J.
BUT!! Bear in mind that you need to get rid of the merged cells in column C. They only create trouble. Secondly, when you create named ranges from the Item codes in column B the hyphens "-" will be replaced by an underscore "_", as named ranges may not contain just any character. So, the code in column J will also have the contain the underscores, or the named formula that will display the picture in K2 for the item in J2, would have to look like this:
=INDIRECT(SUBSTITUTE(NJ!$J$2,"-","_"))No VLOOKUP needed. It's all demonstrated in the attached file, although it needs quite some work to make it look nice.