IMAGE function
an image from a given source.
Lookup and reference · Excel 2024+ · Guided Excel example
Where can you use it?
Reporting and operations teams. Use functions in this group to retrieve a field from an item, employee or order list, select the right record, or move values into another report.
Scenario in the workbook
Test an HTTPS image with alt text. The source must be reachable and Excel must allow external content. Replace the sample address with a direct link to a supported PNG or JPEG.
A worked example from the workbook
| Row | A | B |
|---|---|---|
| 6 | Input | Second input |
| 7 | https://www.microsoft.com/favicon.ico | Microsoft |
| 8 | https://www.microsoft.com/favicon.ico | Logo |
| 9 | https://www.microsoft.com/favicon.ico | Logo alt text |
=IMAGE(A7,B7)Illustrative outputImage if permitted
See the inputs and instructions for all 3 examplesWorked examples
Test an HTTPS image with alt text. The source must be reachable and Excel must allow external content. Replace the sample address with a direct link to a supported PNG or JPEG.
Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.
| Row | A | B |
|---|---|---|
| 6 | Input | Second input |
| 7 | https://www.microsoft.com/favicon.ico | Microsoft |
| 8 | https://www.microsoft.com/favicon.ico | Logo |
| 9 | https://www.microsoft.com/favicon.ico | Logo alt text |
| Trial | Expression | Sample output |
|---|---|---|
| Record 1 | =IMAGE(A7,B7) |
Image if permitted |
| Record 2 | =IMAGE(A8,B8) |
Image if permitted |
| Record 3 | =IMAGE(A9,B9) |
Image if permitted |
If the result is missing
Verify that the URL serves a supported image directly. External content settings can block it.