Here is what I am wanting to accomplish:
I have a spreadsheet with manually inputted values, lets say the number represents a credit score. I then want to have a function that recognizes the number, within a set range, and then because of the value an image/jpg/gif/bmp is pulled up on a different Sheet of the spreadsheet.
For example:
If the credit score is 500, then the formula would pull up and display the image 'score500.jpg'. If the score was 600, image 'score600.jpg' would be displayed.
Hope that makes sense. I have the formula part down for the IF section of it, even got hyperlinks to work as well, but I want the image to show, not a link to it.
Any one got the solution?
Thanks!
Jason
Bookmarks