Ok, thanks,

That will get me all the 'reliefs' in order, but many of the reliefs are
duplicates,
meaning relief 1 might be Smith, and Jones, and Mason. My V lookup is
producing multi Smiths if Smith is the first it found matching relief 1. I
need the names of each match.
The B column has the filtered reliefs in it. Column 40 in the master tab has
the names I need.

Here' my vlookup
=VLOOKUP(B4,MasterTab!$O$21:$BE$982,40,FALSE)

Thanks,

Steve


"Teethless mama" wrote:

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