Auto Filter Custom Filter select contains type in relief OK out



"Steve" wrote:

I'd like to have vlookup return a name if a cell contains the word relief.
And also in consecutive rows. Meaning the word *relief* may be in e.g. 20
cells in a range of 1000. So something like:
vlookup "*relief", 'Master'!, O3:O1000,40,false -this lookup would be on
another sheet.

And if 'relief' was found in rows 26,39,67,75,102, 159, etc., could these
results be put in rows 3 to 23, so I don't have to scroll down looking for
them.

Much thanks,

Steve