Hi, I am using this tut
Excelguru Help Site - VLOOKUP for Pictures
I have everything working except choosing a name doesn't change the picture, I am confused on how to link the "Linked Image" to the Data Validation List that I have. In the example they use several cells that are named, which they hard code into the image link. I don't have that option as I have 1 Cell that is a List Data Validation. This is what I have.
Data validation List that has about 70 account names. The idea is you choose an account and the logo appears in the Account View dashboard.
In the image link I can't change the formula to a "vlookup" as excel gives me an error and says its invalid , basically its saying it can't do that on the picture
Any ideas or how to do it differently?
Excelguru Help Site - VLOOKUP for Pictures
I have everything working except choosing a name doesn't change the picture, I am confused on how to link the "Linked Image" to the Data Validation List that I have. In the example they use several cells that are named, which they hard code into the image link. I don't have that option as I have 1 Cell that is a List Data Validation. This is what I have.
Data validation List that has about 70 account names. The idea is you choose an account and the logo appears in the Account View dashboard.
In the image link I can't change the formula to a "vlookup" as excel gives me an error and says its invalid , basically its saying it can't do that on the picture
Any ideas or how to do it differently?
