Finding a word in a worksheet

Question

Hi!&nbsp;I am trying to find a specific word that is in a worksheet and return the cell address.&nbsp; The word will only be in the sheet 1 time, but it can be located anywhere in the sheet.&nbsp; Because it can be anywhere, I haven't been able to use any of the traditional lookup formulas.&nbsp; Does anyone have any suggestions?

nikolinode · Answer

STRG + Ffor search,write the word you search...and if there..excel find it 🙂I would be happy to find out if I could help.NikolinoI know I don't know anything (Socrates)

tm20204 · Answer

Hi, thank you but it needs to be a formula as there is a long list of words that need to be found and then those references need to be used in a longer formula. Not sure if this is possible?

nikolinode · Answer

TM20204&nbsp;&nbsp;

nikolinode · Answer

NikolinoDE&nbsp;&nbsp;or so 🙂&nbsp;Matrix FormelAttention, matrix formula!Don't type the braces {}but the cell withShift + Ctrl + Enterleave alone instead of enter.&nbsp;I would be happy to find out if I could help.&nbsp;&nbsp;NikolinoI know I don't know anything (Socrates)&nbsp;

tm20204 · Answer

Hi I'm not sure this will work.&nbsp; I'll try to be clearer.&nbsp; On one sheet I have a list of words:&nbsp;GreenBoyAppleThomasCatHouse&nbsp;On another sheet, I have a giant data set where the words can be anywhere (There are no blank cells but have left some blank to illustrate my point).&nbsp; I need to know what cell each word is in.&nbsp;&nbsp;&nbsp;ABCDEFG1Green&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3&nbsp;&nbsp;&nbsp;&nbsp;Boy&nbsp;&nbsp;4&nbsp;Apple&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Cat6&nbsp;&nbsp;House&nbsp;&nbsp;&nbsp;&nbsp;7&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Thomas&nbsp;&nbsp;&nbsp;So in the first sheet it looks like this:&nbsp;GreenA1BoyE3AppleB4ThomasF7CatG5HouseC6&nbsp;&nbsp;&nbsp;NikolinoDE&nbsp;

Forum Discussion

Finding a word in a worksheet

8 Replies

Resources