# Search results

... Excel. We could, for example, use the

**VLOOKUP**function or the MATCH function ...... one or more sheets. #REF! errors with

**VLOOKUP**You may see a #REF! error with the**VLOOKUP**function , when a column is ... incorrectly. In the screen below,**VLOOKUP**returns #REF! because there is ...... . The formulas below are good examples:

**VLOOKUP**case-sensitive**VLOOKUP**multiple criteria In these ... (in memory) that can be used by the**VLOOKUP**function to workaround a ...... XLOOKUP for a case-sensitive match.

**VLOOKUP**option The**VLOOKUP**formula also supports wildcards ... when set to exact match. The equivalent**VLOOKUP**formula for this example is: = ...... dates and times, lookup values with

**VLOOKUP**and INDEX & MATCH, count and sum ...... language for tables. Examples include

**VLOOKUP**, INDEX and MATCH, and SUMIFS. ...... – to check the number of items

**VLOOKUP**function – to lookup irregular ... the example shown, we do this with the**VLOOKUP**function : =**VLOOKUP**( C5 , wordtable , 2 , 0 ) where ...... are three examples: 1. You can use use

**VLOOKUP**to perform a lookup with ... first and last names, so that**VLOOKUP**can be used to find department ...... are performing a lookup operation with

**VLOOKUP**or INDEX and MATCH , you must ... show how this difference affects a**VLOOKUP**formula: =**VLOOKUP**( "00127" , range , column , ...... at the final formula which uses the

**VLOOKUP**function , and I'll show you why ...