I have a workbook that has tab called summary and has a balance facility whereby if the total is zero its classed as balanced. If not its classed as unbalanced.
I've been trying to create a cell that would show a picture of a smiling emjoi if balanced, and otherwise a sad face.
I've seen some info online where it says you can achieve this using the INDEX MATCH function.
So I would have 2 different pictures in cells A1 and B1, then in A2. I'd have balanced, and B2 if have unbalanced. You then use the index match feature to get the desired result in cell C1.
If this makes sense, cam anyone help? I'm working in excel 2010.
Thanks in advance.