# Search results

... MATCH over another lookup function like

**VLOOKUP**is that INDEX and MATCH can ...... conditions in a single function.

**VLOOKUP**can sometimes be used to replace ...... error is detected. This page shows a

**VLOOKUP**example . 3. Prevent calculation ... For example, in the screen below, the**VLOOKUP**function in F3 is misspelled ... are classic lookup functions, including**VLOOKUP**, HLOOKUP, LOOKUP, and MATCH. For ...... tempted to use a lookup function like

**VLOOKUP**, XLOOKUP , or INDEX and MATCH. ... like <a href="/excel-functions/excel-**vlookup**-function">**VLOOKUP**</a>, <a ...... multiple matches). Lookup formulas like

**VLOOKUP**and INDEX + MATCH can easily ...... solar system. Without named ranges, a

**VLOOKUP**formula to fetch "Position" from the table is quite cryptic: =**VLOOKUP**( $H$4 , $B$3:$E$11 , 2 , 0 ) ... we can write formulas like this: =**VLOOKUP**( planet , data , 2 , 0 ) // ...... - Excel shows formula but no result The

**VLOOKUP**formula is correct, why no ...... advantages of INDEX and MATCH over the

**VLOOKUP**function is the ability to ...