Assistance Needed with Indirect Formula Looking Up Images

**taskmaster01** · 08-19-2014, 06:02 PM

Hi guys any help on this issue would be greatly appreciated.
I have created a rough excel doc with different products on each sheet. The idea is to have the main sheet be able to compare the products just by selecting the devices from the drop down menu to compare side by side.
I have used the INDIRECT FUNCTION to accomplish this which has worked great for pulling the information needed but I am having trouble bringing the image associated to the product aswell.
The INDIRECT function is not working and I have also tried MATCH but cant get it to work. I am a beginner so most definitely something I am doing wrong so if anyone could explain it step by step it would be a MASSIVE help.

Ive attached a link to the file below so you can see my prototype, as you can see all the data is there except the image which needs to be pulled from the other sheet depending on what has been selected in either B2, C2 or D2

https://www.dropbox.com/s/9vju0l5bxw...20%281%29.xlsx

**protonLeah** · 08-19-2014, 06:29 PM

To attach a Workbook
(please do not post pictures or links to worksheets)

Click Advanced (next to quick post),
Scroll down until you see "Manage Attachments",
Click that then select "add files" (top right corner).
Click "Select Files" find your file, click "open" click "upload"
Once the upload is completed the file name will appear below the input boxes in this window.
Click "Done" at bottom right to close the Attachment Manager.
Click "Submit Reply"

**taskmaster01** · 08-21-2014, 04:03 PM

Yeah I do apologize but the size was over the attachment limit due to the images, which is the issue I need help with.

Anybody here that can help me with my issue please, any help would be greatly appreciated.