LOOKUP function

description:

Look up a value in a one-column range.

 

syntax:

=MATCH( lookup_valuelookup_vector[result_vector] )

 

required arguments:

lookup_value The value to match in lookup_vector.
lookup_vector The one-row, or one-column range to search.

 

optional arguments:

[result_vector] The one-row or one-column range of results.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.