Search array and return rows?

marrott2,

It sounds like you could just use vlookups instead. Can you post a small sample workbook so that we can see more clearly what you need?

~tigeravatar

Here is a sample file. Im trying to search by the first column and return the entire row that matches it to another worksheet

marrott2,

I have attached a modified version of your sample workbook. I named the sheet with all the information Master List and created a new sheet called Sample Sheet. In sample sheet, I put in some random items from column B of the Master List. Then I just used formulas to bring in the necessary information.

Hope this helps,
~tigeravatar

That wasnt exactly what I was looking for. I reposted another sample file that kind of shows the format more of what I want. On the "Search" worksheet the user should be able to enter a partial or full "stake name" hit the search button, and scan through the "sample data" worksheet and return all matching cells and corresponding row data.

marrott2,

See attached. I used a drop-down list in the Search Form sheet (in cell B2). Choosing an item will result in bringing the information from the Sample Data sheet. Changing or adding stake names in the Sample Data sheet will automatically update the drop-down list contents. The reset button clears everything (this can also be accomplished by deleting B2's contents).

Hope that helps,
~tigeravatar

This is definitely faster than the method I had before. Thanks for your help!

here's one more question though... the drop down list in the full blown program will contain over 1400 values. how might I create a search so the user can input say just part of the "stake name" and it will return all the values that contain that?

I updated the code you sent me before the most recent one. Got it to work with my master list, updated it so that it searches for partial text and includes error checking as well. I couldnt get your combo box to work in the most recent post but I really appreciate your help.