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 1,204 views

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,700 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