Formula for inserting a thumbnail picture into excel cell based on another cell s value

0 votes

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 by Kithuzzz
• 28,900 points
166 views

1 answer to this question.

0 votes

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.

answered Oct 31, 2022 by narikkadan
• 53,520 points

Related Questions In Others

0 votes
1 answer

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

answered Nov 25, 2022 in Others by narikkadan
• 53,520 points
75 views
0 votes
1 answer

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

answered Jan 23 in Others by narikkadan
• 53,520 points
37 views
0 votes
1 answer

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

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

answered Jan 29 in Others by narikkadan
• 53,520 points
41 views
0 votes
1 answer

VBA Excel: Draw line between cells based on cell value

In accordance with your description and with ...READ MORE

answered 2 days ago in Others by narikkadan
• 53,520 points
25 views
0 votes
1 answer

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

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
215 views
0 votes
1 answer

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

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

answered Feb 16, 2022 in Others by Edureka
• 13,630 points
392 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

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

Feb 17, 2022 in Others by Edureka
• 13,630 points
175 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

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

answered Feb 18, 2022 in Others by gaurav
• 22,960 points
165 views
0 votes
1 answer

Excel formula for searching two text in one cell and return values based on the result

You can include a second IF within ...READ MORE

answered Oct 10, 2022 in Others by narikkadan
• 53,520 points
206 views
0 votes
1 answer

Excel Define a range based on a cell value

Let's say that cells A1, A2, A3, ...READ MORE

answered Nov 8, 2022 in Others by narikkadan
• 53,520 points
160 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP