You should try using autofilter,
Set row 1 on your worksheet as you described:

State City Institution Name Number

Select all four columns and then from the Main Menu bar select:
Data- Filter - Autofilter
Then you can set your criteria based on any of the above columns or a
combination of them.
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"ajborj" wrote:

Hi to everyone. I have a little project and I hope someone could assist me
for this. I have a worksheet with four columns but the number of data exceeds
4000 rows. I understand excel can search using the function "ctrl+f" but what
I would like to achieve is that, I need to create a search box that would
return the matched keywords and highlight all data or matches in the
worksheet.
The worksheet would appear like this:
State City Institution Name Number

I tried creating userform that would search for the three fields state, city
and institution name and return all available information. Its like searching
data from the database. Can someone assist me on this?