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/