Article: VLOOKUP for Pictures

[Ken Puls]

You can view the page at http://www.excelguru.ca/content.php?...P-for-Pictures

[JeffreyWeir]

This is very cool, Ken.

[LuisPacheco]

Really Cool --Good Job

[Ken Puls]

Thanks guys.

[royUK]

I use something similar for Dashboards, enabling the user to change Charts & even data views.

[rizwan.planning]

Wallha very good

[Victoria]

I have tried this method and actually a similar method and I get an "Reference not valid" when it comes to changing the picture formula to =Day_01. Any suggestions on what I am doing wrong?

[amit4blog]

It's great...

[Iryna]

Hi, I have the same problem as Victoria had. Are you sure, we select A4:E5 in this step and not A3:E4?
thanks

• Select cells A4:E5
• Go to Formulas -->Defined Name -->Create from selection
• Choose to created names from values in the Top Row (only)

[okili]

Hi, I have the same problem as Victoria had. Are you sure, we select A4:E5 in this step and not A3:E4?
thanks

• Select cells A4:E5
• Go to Formulas -->Defined Name -->Create from selection
• Choose to created names from values in the Top Row (only)

Hi, Victorya and Iryna, try this:
First just create names without Indirect formula, then change formula of picture to that name and after this add indirect formula. This would circumvent the "Reference not valied" error.