# Search results

... "index" of the first match based on a

**lookup**value in a range. MATCH supports ... asterisks (*) on either side. The**lookup**array is the range B6 to B11, and ... the position of the first cell in the**lookup**range that contains the text ...... you can easily do so with the V

**LOOKUP**function. In the example shown, the V**LOOKUP**formula looks like this: = V**LOOKUP**( id , data , 3 , FALSE ) How ...... to arbitrary values, you can use the V

**LOOKUP**function. In the example, we need ... arbitrary), we need to do some kind of**lookup**. The V**LOOKUP**function provides an easy way to ...... the MATCH function receives a single

**lookup**value, and returns a single match ... we are giving MATCH an array for**lookup**value, so it will return an array ... of results, one per element in the**lookup**array. MATCH is configured for ...... numeric values, you can use the V

**LOOKUP**function with a simple table. In ... arbitrary), we need to do some kind of**lookup**. The V**LOOKUP**function provides an easy way to ...To match the "next highest" value in a

**lookup**table, you can use a formula ... above approach works fine for simple**lookup**s. If you want to use MATCH to ... more traditional way, you can sort the**lookup**array in descending order, and ...Using V

**LOOKUP**from another sheet is very similar to using V**LOOKUP**on the same sheet. In the example shown, the formula in F5 is: = V**LOOKUP**( B5 , Sheet2 ! $B$5:$C$104 , 2 , ...... ( RAND (), D$5:D$10 ) Inside MATCH, the

**lookup**value is provided by the RAND ... a random value between zero and 1. The**lookup**array is the range D5:D10, locked ... largest value less than or equal to the**lookup**value*. In practical terms, this ...... E4:F10 shows the discount returned by X

**LOOKUP**for several random quantities. X**LOOKUP**is configured to use the quantity ... The formula in F5, copied down, is: = X**LOOKUP**( E5 , qty , disc , - 1 ) The ...By default, V

**LOOKUP**will do an approximate match. ... This is a dangerous default because V**LOOKUP**may quietly return an incorrect ... result when it doesn't find your**lookup**value. Read below to see some ...