VLOOKUP Function

Posted by Unknown - 7:21 AM -
0
 VLOOKUP function 

 This performs a vertical lookup by searching for a value in the Range and returning the value in the same row .

Syntax

VLOOKUP( value, table_array, index_number, [not_exact_match] )
Example
=VLOOKUP(10248, A1:B6, 2, FALSE)
Result: #N/A

=VLOOKUP(10248, A1:B6, 2, TRUE)
Result: "Apples"

0 comments:

Subscribe to: Post Comments (Atom)