display a picture in a cell when the picture name is selected
Hi
I have done the above where when I select a picture name from a drop down list it displays the relevant picture in another cell by using the IF function in the named formula
My question is why cant I use VLOOKUP instead of IF in the named formula. When I use it it comes with an error.
Re: display a picture in a cell when the picture name is selected
Hi... it may be helpful for you to post a workbook to clarify your question a bit. If it's sensitive data, or pictures that you cannot share, consider altering a subset of them - without knowing the structure of your data, where the drop down is, how the IF statement is called, and what the error is, it's difficult to assist you.
The good people here are incredibly helpful, but the more info you can provide, the better.
Re: display a picture in a cell when the picture name is selected
Hi
Thanks for your quick response
I have attached a sample file where in the 'Main' chart when I select a picture from the drop down menu it will automatically display the relevant picture from the other sheet
I have done this by using the IF function in the formula named as picture ( =IF(Main!$F$5="house",pics!$C$6,IF(Main!$F$5="box",pics!$C$7,pics!$C$8)) & it works perfectly
what I need to know is whether the IF function can be replaced with a VLOOKUP
Bookmarks