Interactive word search

mari_hitz

Board Regular
Joined
Jan 25, 2011
Messages
101
Hi all, hope you are all good and safe given the circumstances. I wanted to obtain your help to know if what I am trying to do can actually be done in Excel.
I'm trying to create a word search in excel, but in addition I would like that when a word is found for a pop up or a message to appear. The idea is that this pop up or message contains information about that specific word.
I had tried to see if probably by selecting a range then on a cell the word can be found and have another formula that based on the word returns a message but I don't know if this is possible.
I have already my word search done, but I'm struggling with the pop up message and how to make it appear based on the word found. Is this possible? Thanks for the help!
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Hi, I'm not sure to understand the exact need. Seems you need a simple lookup. Assuming you'd have a table with the words and the pop-up message next to it you can make this text appear in a cell or a shape.
Cell Formulas
RangeFormula
C4C4=IFERROR(INDEX(tWords[Pop-up],MATCH(vWord,tWords[Word],0)),"Description will appear here")
Named Ranges
NameRefers ToCells
vWord=Sheet1!$B$4C4
Cells with Data Validation
CellAllowCriteria
B4List=$B$16:$B$35
1590240364638.png
 

Attachments

  • 1590240248614.png
    1590240248614.png
    36.6 KB · Views: 1
Upvote 0

Forum statistics

Threads
1,214,648
Messages
6,120,726
Members
448,987
Latest member
marion_davis

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top