Search Rows in a spreadsheet
 

I have a large spreadsheet with multiple columns and many rows. One ro
is product Name, another column is Product Description. Can I searc
each row in this sheet by using two terms, for example, "IBM" fo
Product Name and "Desktop PC" for Product Description. Also, i
general, can the search term include a wild card???

As always, thanks for all the help

--
Message posted from http://www.ExcelForum.com

Search Rows in a spreadsheet
 

Using the find method
You can search for IBM, then check if the description cell contains Desktop
PC. If so, you found it. If not, continue the search (Find Next). See the
help example for FindNext.

Yes, you can use some wildcards in the argument to the Find Method.
What:="ABC*", Lookat:=xlWhole

will find cells that start with ABC for example.

--
Regards,
Tom Ogilvy

"QandA " wrote in message
...
I have a large spreadsheet with multiple columns and many rows. One row
is product Name, another column is Product Description. Can I search
each row in this sheet by using two terms, for example, "IBM" for
Product Name and "Desktop PC" for Product Description. Also, in
general, can the search term include a wild card???

As always, thanks for all the help.


---
Message posted from http://www.ExcelForum.com/

Search Rows in a spreadsheet
 

Thanks Tom...

My main question, can you search the rows of the sheet using two term
at the "same time"? I would like to do a search in one time and labe
the row where the search is successful for the two terms and not jus
one at a time

--
Message posted from http://www.ExcelForum.com

Search Rows in a spreadsheet
 

No. But since you achieve the expected results with the method I provided,
I don't see the difference.

An alternative would be to use the Autofilter to filter each column on the
respective value, then pick up the visible row (if any).

You can do this manually with the macro recorder on to get the code.

--
Regards,
Tom Ogilvy



"QandA " wrote in message
...
Thanks Tom...

My main question, can you search the rows of the sheet using two terms
at the "same time"? I would like to do a search in one time and label
the row where the search is successful for the two terms and not just
one at a time.


---
Message posted from http://www.ExcelForum.com/

Search Rows in a spreadsheet
 

Many thanks for you input Tom

--
Message posted from http://www.ExcelForum.com