Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gadgetwiz

    Search multiple words in Microsoft Excel

    Hi, Skip. Sorry, my hands are full with some other stuff to finish by today. I'll post it as soon as I can. thank you so much for your help.
  2. gadgetwiz

    Search multiple words in Microsoft Excel

    Ok, I don't 100% understand this part: "Find method with xlPart in VBA code." What I meant by "Find feature in Excel" was the find menu. I didn't know about Find function. I quickly tried this, but got a Value error: =FIND("iphone 4 crystal screen",C2:C10000) Could you let me know how to use...
  3. gadgetwiz

    Search multiple words in Microsoft Excel

    OK, for example, a row in a worksheet(product_list) to create reference table(SKUprice) looks like this: Camera ABC00001 ABC SONY a55 Front Screen Protector [Crystal Clear] $1.99 The reference table, "SKUprice" has SKU on the far left, product name, and price. (ABC00001 is SKU, and "ABC...
  4. gadgetwiz

    Search multiple words in Microsoft Excel

    Hi, Skip. Thanks for your reply. There are couple problems, though. 1. Actual product name is painfully longer. For example, the actual name of the one that I wrote could be "ABC iphone 4 ultra crystal clear front screen protector set" something like this.. 2. There is already the reference...
  5. gadgetwiz

    Search multiple words in Microsoft Excel

    Hi. This has given me a headache since yesterday when one of my suppliers required to use their own order from that I have to search an SKU number from the list of 1000 items in several worksheets. I need to set up a quick way to search multiple words in Microsoft Excel to make this...

Part and Inventory Search

Back
Top