Excel – Search/Lookup
Search all columns and return rows containing search string
Search for a text string in an excel table
Search all columns and return rows where search string equals cell value
Search for a cell value in an excel table
Lookup x and y in a cross reference table in excel
Looking up data in a cross reference table in excel
Search each column with corresponding search string and return rows where both search strings are found
Lookup with multiple criteria and display multiple search results using excel formula
Search both columns with each search string and return rows where both search strings are found
Lookup with multiple criteria and display multiple search results using excel formula, part 2
Search each column with corresponding search string and return rows where all search strings are found
Lookup with multiple criteria and display multiple search results using excel formula, part 3
Search column with any number of search strings and return cells containing all search strings
Search for multiple text strings in multiple cells in excel
Search for multiple text strings in multiple cells in excel, part 2
Search and display all cells that contain all search strings in excel
Search a column containing numbers using a numerical range and return rows that match given range
Search and display a range of values in excel
Lookup a value and return multiple corresponding values
Using array formula to look up multiple values in a list
Misc
How to create a useful search formula
Find the largest number in a dynamic column using excel formula
Search three columns on three sheets
Search three columns on three sheets, part 2
Finding values in an excel list
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form