In connection with another problem, I need to do the following:

if the value of cell A1 is greater than 100, cell C1 will show a thumbnail image of my face. If the value of cell A1 is less than 100, cell C1 will show a thumbnail image of my friends face.

The face thumbnails are PNG files that are kept on my desktop.

Without using Macros, I'm attempting to achieve. I suppose there could be a formula like

=IF(A1>100,SETCELLIMG(c:\users...\Desktop\myface.png))

I am aware of how to drag and drop a *.png thumbnail into a cell using the mouse, however the instructions I have called for cutting and pasting. Additionally, the instructions I have to prevent the thumbnail from changing based on the value of another cell. I'm not really sure if this is even doable in excel.

This absurd problem serves as a proof-of-concept for how I will approach a different challenge.

Oct 31, 2022 in Others 890 views

## 1 answer to this question.

Here is a really excellent tutorial on how to lookup an image contained in a cell: https://www.excelguru.ca/content.php?279-VLOOKUP-for-Pictures

I hope this helps you.

• 63,180 points

## In a excel formula I need to create a list of names on one sheet based upon criteria/data of another sheet

The final formula is: =IF(ROWS(\$H\$3:H3)<=\$I\$1,INDEX(Personnel! ...READ MORE

## Attributing the value of a cell based on another corresponding cell

Put in cell B1 of Sheet1: =INDEX(Sheet2!B:B;MATCH(A1;Sheet2!A:A;0)) Drag it ...READ MORE

## Select a range in Excel based on the value of a cell

Try this: Dim WorkRng As Range Set WorkRng = ...READ MORE

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE