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.

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.

Thanks!

sorry for interrupting this post...but how do I submit a question? Thanks!

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

Thanks

Hi
First get registered with a UID & Password then you can submit a post. Its free

Rgds

Not with VLOOKUP I guess, try this:

=INDEX(pics!$C$6:$C$8,MATCH($F$5,pics!$B$6:$B$8,0))

But you need to set up the table like in the file attach

Thank you very much - it worked