Searching an excel with two search words (multiple lookup) using vba macro [closed]

by

You are looking for a Lookup with multiple criteria. A quick search gives several useful links, listed below. I have marked with * those that I have answered.
I have filtered out some of the links that actually deal with other issues.

As seen in the links, there are several options to achieve your goal. I personally prefer those that do not need array formulas, using an answer to question 1 with LOOKUP or an answer to question 2 with SUMPRODUCT.

Since you mentioned that you need a VBA solution, you can use WorksheetFunction to use an Excel formula in VBA code, or check answers to question 7.

  1. Multiple Column vs Multiple Column Lookup *

  2. Multiple-column based lookups in Excel *

  3. Lookup Database (Multiple criteria)

  4. Excel Lookup with multiple queries

  5. Multiple VLOOKUP LOOKUP IF Statement?

  6. Returning a value if three columns match in excel *

  7. VLookup multiple columns

  8. Comparing two columns in one Excel sheet, to two columns in another sheet, and if they match, copy data from another column *

  9. Macro for vlookup with 2 vertical criteria *

  10. http://spreadsheets.about.com/b/2014/01/08/excel-lookup-formula-using-multiple-criteria.htm

  11. http://fiveminutelessons.com/learn-microsoft-excel/use-index-lookup-multiple-values-list

  12. http://blogs.office.com/2012/04/26/using-multiple-criteria-in-excel-lookup-formulas/

  13. http://www.xl-central.com/lookup-multiple-criteria.html

  14. http://www.get-digital-help.com/2012/05/22/lookup-multiple-values-in-different-columns-and-return-a-single-value/

PS: The (probably partial) list of (probably) duplicated questions provided above shows the usefulness of what was proposed in https://meta.stackexchange.com/questions/211366/group-duplicate-questions-for-convenience

More Related Contents:

  1. How do I get values from a hidden worksheet using VBA [closed]
  2. How to copy cells that contain certain text to another worksheet [closed]
  3. VBA Macro for copying and pasting columns on same excel sheet
  4. Excel VBA, code to count the # of filled cells, then find highest and 2nd highest and subtract the corresponding column #’s [closed]
  5. Levenshtein Distance in VBA [closed]
  6. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  7. How do I base64 encode a string efficiently using Excel VBA?
  8. Assign event handlers to controls on user form created dynamically in VBA
  9. Programmatic Access To Visual Basic Project Is Not Trusted
  10. Can I make this macro more efficient or faster?
  11. Conditional Formatting using Excel VBA code
  12. Controlling IE11 “Do you want to Open/Save” dialogue window buttons in VBA
  13. How to get the background color from a Conditional Formatting in Excel using VBA
  14. VBA Excel Populate ListBox with multiple columns
  15. How to Lock the data in a cell in excel using vba
  16. How to use Events with Option Button Controls on Userform [duplicate]
  17. How do I use variables to set properties in VBA (Excel)
  18. VBA: Else without If Error
  19. Workbooks.Open Method in VBA
  20. Windows().Activate works on every computer except one
  21. How to highlight a cell using the hex color value within the cell?
  22. Convert RTF (Rich Text Format) code into plain text in Excel
  23. lastrow and excel table.
  24. Open a workbook from VBA and disable Workbook_Open() code?
  25. Creating form programmatically in the module using vba
  26. How to filter listbox values based on a Textbox value
  27. Find and FindNext for Excel VBA
  28. How to have vba execute every 10 minutes?
  29. Read and write from/to registry in VBA
  30. Unable to read data from a CSV using ADO due to the driver thinking I am working with integers/number and showing nulls instead of text

Leave a Comment