WPS Spreadsheets: Display Related Notes and Images from a Drop-Down List
Question details
The user needs a drop-down selection in WPS Spreadsheets to return the matching note, description, and image.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A worksheet contains selectable options and a lookup table with related text and image references.
- Observed behavior
- The selected drop-down value does not yet display its associated note, description, or image automatically.
Prepare a lookup table with one unique option per row, along with its note, description, and image URL or image reference. Confirm whether your WPS Spreadsheets version supports the IMAGE function before choosing the image-display method.
Use a lookup formula and IMAGE for drop-down notes and image URLs
Use this method when the image is available through a direct URL and your WPS Spreadsheets version supports the IMAGE function.
The drop-down cell supplies the selected key, while lookup formulas retrieve the matching text and image reference from the source table. XLOOKUP is suitable where supported; VLOOKUP or INDEX and MATCH can be used in versions without XLOOKUP.
In a separate area or worksheet, create columns for Option, Note, Description, and Image URL. Enter one matching record per option and ensure the Option values are unique.
Select the input cell, open the Data tab, choose Data Validation, select List, and set the source to the Option column in your lookup table.
Select the output cell for the note and enter a formula such as =XLOOKUP(A2,$H$2:$H$20,$I$2:$I$20,"") where A2 is the drop-down cell, H contains options, and I contains notes.
In the image output cell, use a formula such as =IMAGE(XLOOKUP(A2,$H$2:$H$20,$J$2:$J$20,"")) where J contains direct image URLs. Press Enter and test several drop-down choices.
Display stored pictures with named ranges or linked pictures
Use this fallback when images are inserted in cells, stored locally, or when the IMAGE function is not available in your WPS version.
Build Dynamic Drop-Down Lookups in WPS Spreadsheets
WPS Spreadsheets lets you create validated drop-down lists, organize related data in lookup tables, and use formulas to return matching notes, descriptions, and supported image references in one worksheet.
- 1. Create the source table: Open WPS Spreadsheets and place each option, note, description, and image reference in separate columns.
- 2. Add a drop-down list: Select the input cell, open Data, choose Data Validation, select List, and specify the option range.
- 3. Return matching text: Use XLOOKUP, VLOOKUP, or INDEX and MATCH in the output cells to retrieve the note and description for the selected option.
- 4. Show the image: Use IMAGE with a returned direct image URL when supported, or use named ranges and linked pictures for inserted images.
Frequently Asked Questions
Can WPS Spreadsheets display a note automatically when I choose an item from a drop-down list?
Yes. Put the options and notes in a lookup table, create a list with Data > Data Validation, and use XLOOKUP in the output cell. For example, =XLOOKUP(A2,$H$2:$H$20,$I$2:$I$20,"") returns the note for the selection in A2.
How can I display an image associated with a WPS Spreadsheets drop-down choice?
If your version supports IMAGE, store direct image URLs in the lookup table and use a formula such as =IMAGE(XLOOKUP(A2,$H$2:$H$20,$J$2:$J$20,"")); otherwise, use named ranges or linked pictures for images inserted into the workbook.
Why does the IMAGE formula not show the expected picture?
The URL may not be a direct image link, the website may block external requests, or your WPS version may not support IMAGE. Test the URL in a browser and switch to a named-range or linked-picture method if necessary.
Can I use VLOOKUP instead of XLOOKUP for the related note?
Yes. If the selected value is in the first column of the source table, use a formula such as =VLOOKUP(A2,$H$2:$J$20,2,FALSE). The column number must point to the note or description column you want to return.
