# LOOKUP Articles: Excel and Google Sheets

All resources related to LOOKUP for Excel and Google Sheets.

### LOOKUP

Solutions When Your Excel Lookup Returns 0
Excel VLOOKUP retrieves 0 value for the empty cells in the lookup array. To get an empty string as a lookup result we should use several formulas IF, LEN and VLOOKUP. This step by step tutorial will assist all levels of Excel users to get an empty string as a...
Learn How to Perform Approximate Match in Excel
Excel allows us to lookup values using an approximate match with INDEX and MATCH functions. The MATCH function returns a row for a value in a table, while the INDEX returns a value for that row. This step by step tutorial will assist all levels of Excel users to learn...
How to Limit Your Search to a Column in Excel
Excel allows a user to limit a search of value to a single column. This step by step tutorial will assist all levels of Excel users to learn how to limit a search to a column in Excel. Figure 1. Searching in a single column Setting up Our Data for...
What Are the Different Ways to Do Lookups in Excel?
Excel allows us to lookup values in two ways. Using the VLOOKUP function or with INDEX and MATCH functions. The MATCH function returns a row for a value in a table, while the INDEX returns a value for that row. This step by step tutorial will assist all levels of...
How to Use the table_array Argument in an Excel Lookup Function
Excel allows us to lookup values from a table_array using the VLOOKUP function. This step by step tutorial will assist all levels of Excel users in using the table_array argument in an Excel VLOOKUP function. Figure 1. The final result of the formula Syntax of the VLOOKUP formula The generic...
Here is How You Can Use HLOOKUP in Google Sheets
Google Sheets allows a user to get a value from a table using the horizontal lookup. This is possible using the HLOOKUP function, which allows us to get a value from a table organized into rows. This step by step tutorial will assist all levels of Excel users in doing...
Learn How to Use INDEX and MATCH on Multiple Columns in Excel
We can use an array formula that is based on the MMULT, TRANSPOSE, COLUMN, and INDEX functions to lookup a value by matching across multiple columns. The steps below will walk through the process. Figure 1- How to Use INDEX and MATCH functions on Multiple Columns General Formula =INDEX(range1,MATCH(1,MMULT(--(range2=criteria),TRANSPOSE(COLUMN(range2)^0)),0)) Formula...
Learn How to Use VLOOKUP and HLOOKUP Together in Excel
We can use a nested formula that combines the VLOOKUP and HLOOKUP Functions in excel to retrieve values from a table. Approximate and exact matching is supported by this combined formula and wildcards (* ?) are for finding partial matches. The steps below will walk through the process. Figure 1-...
How to Use INDEX and MATCH Together in Google Sheets
We can use a formula that is based on the INDEX and MATCH functions to lookup a value in a table in a Google Sheet. Unlike in excel where the result is entered with CRTL+SHIFT+ENTER, the result is entered with the enter key only for Google Sheets. The steps below...
Learn How to Use Fuzzy Lookup in Excel
We can use Excel Fuzzy Lookup Add-In to match similar, but not exactly matching data. FUZZY LOOKUP returns a table of matched similar data in the chosen column. FUZZY LOOKUP is useful for comparing two same data sets where one of them comes from an external source and can be...
1 2 3 6 7