Excel thingy... Tip for using OFFSET() function to restrict a droplist.

[kunkel321]

Nobody at home or work will appreciate this thing I did.  
I'll just leave it here.  



Excel file attached...
EDIT:  There's not macros...  And guaranteed no maljunk.

[IainB]

Thanks! That's rather nifty if you need to set up (say) an efficient data input form for a user.
Otherwise I would usually use Tables and Filters nowadays.
Hmm, but I wonder whether you could use Regex in there...    
Excel is a pretty powerful tool.

[kunkel321]

Yea, I also make use of Tables...
I have a dashboard type of thing though that pulls from a Table, and also allows independent lookups of individual people...

There's about 1200 people in my list, so I was getting tired of scrolling the whole list.

I don't think it's possible to use Regex in formulas (only in VBA).  You can use wildcards * ? in some though. 

[IainB]

Ah, I see why you use it now. Yes, of course.
I just might have a use for it actually. I may be required to develop a person lookup for an Excel database of a few thousand members of an alumni group that was set up a few years back and has now grown quite large.