LOOKUP Articles: Excel and Google Sheets

Perform a Two Dimensional Lookup in Excel

Excel allows a user to do a two-dimensional lookup using the INDEX and MATCH functions. The MATCH function returns a row and a column for values in a table, while the INDEX returns a value for row and column. This step by step tutorial will assist all levels of Excel...

Learn How to Perform a Two Dimensional Lookup in Excel

Excel allows a user to do a two-dimensional lookup using the INDEX and MATCH functions. The MATCH function returns a row and a column for values in a table, while the INDEX returns a value for row and column. This step by step tutorial will assist all levels of Excel...

How to Lookup a Value Between Two Numbers in Excel

Excel allows a user to lookup a value between two numbers using the LOOKUP function. This step by step tutorial will assist all levels of Excel users in learning how to lookup a value between two numbers in Excel. Figure 1. The result of the nested LOOKUP function Syntax of...

Tips on Performing an INDEX and MATCH with Two Criteria

Excel allows a user to do a lookup with two criteria using the 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...

Learn How to Use the IFERROR, INDEX, and MATCH Functions Together

Excel allows us to lookup values 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. If no value is found, we can avoid error using the IFERROR function. This step by step tutorial...

Here is How You Can Combine an IF Statement and a Lookup Function in Excel

Excel allows a user to combine the IF statement and the VLOOKUP functions. This step by step tutorial will assist all levels of Excel users to learn how to combine an IF statement and a lookup function in Excel. Figure 1. The result of the formula Syntax of the VLOOKUP...

Learn How to Return Multiple Match Results in Excel

Excel allows us to return multiple match result of a lookup using the TEXTJOIN and IF functions. This step by step tutorial will assist all levels of Excel users to learn how to return multiple match results in Excel. Figure 1. The final result of the formula Syntax of the...

Here is an Overview of Excel’s Horizontal Lookup Function

Excel 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 a...

Learn How to Perform a Multi-Column Lookup in Excel

Excel allows a user to do a multi-column lookup using the 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 in learning...

Here is How You Can Lookup Values Across Multiple Sheets in Excel

Excel allows a user to lookup values across multiple sheets using the VLOOKUP function. This step by step tutorial will assist all levels of Excel users to lookup values across multiple sheets in Excel Figure 1. The result of the VLOOKUP function Syntax of the VLOOKUP Formula The generic formula...