ExcelFlux

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

RowAB
6InputSecond input
7https://www.microsoft.com/favicon.icoMicrosoft
8https://www.microsoft.com/favicon.icoLogo
9https://www.microsoft.com/favicon.icoLogo alt text
Record 1
=IMAGE(A7,B7)

Illustrative outputImage if permitted

See the inputs and instructions for all 3 examples

Worked 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.

Microsoft Excel reference