LOOKUP function


Look up a value in a one-column range.



=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.