Using images in formulas

[caligirl]

I'm using Excel 2011. I have a spreadsheet created that has 6 tabs. One tab is the master tab where all the information is entered and then I have 5 tabs that are all names of departments. I want to have the user enter in the information on to the Master tab. The department tabs all have "IF" functions written in so that IF the code given to the row is for example W, then it will reference it on the W tab, if not it will leave it blank.

I have TWO problems.

1. When my department tab looks up the master tab, if there is no information it is leaving a 0, even though in my statement I have instructed it to be ""

=IF(Master!A1="w", Master!A1, "")

2. The other and more pressing problem is that one of the cells contains a picture and this also needs to be referenced across into the department tab.

If anyone could offer any help at all I would really really appreciate it!!!

 

[GlennUK]

In what way does the cell contain a picture?

 

[caligirl]

The images are just inserted as images, and each row has a different image

 

[GlennUK]

There is a long thread on this:

http://www.mrexcel.com/forum/showthread.php?t=100737

see if any of that is of use to you.

 

[caligirl]

I looked at this but wasn't able to apply it to my situation

 

[GlennUK]

How about this:

http://www.mcgimpsey.com/excel/lookuppics.html

 

[caligirl]

Thanks Glenn I saw this also, but I'm not sure about where the pictures are located to reference to, I downloaded their sample file and still couldn't figure it out.

 

[GlennUK]

All the pictures are in the sheet, but are hidden when not referenced by result in cell F1. You could have a copy of all of your pictures in each department tab, and have the same kind of code to unhide and position each picture that matches your calculations.