Excel Formulas and Functions: The Step by Step Excel Guide on how to Create Powerful Formulas by Suman Harjit

Excel Formulas and Functions: The Step by Step Excel Guide on how to Create Powerful Formulas by Suman Harjit

Author:Suman, Harjit [Suman, Harjit]
Language: eng
Format: epub, pdf
Published: 2020-03-14T16:00:00+00:00


Functions Used

LOOKUP

LOOKUP Function Explained

The LOOKUP function is used to lookup a value from a single row or column and returns the value from another row or column in the same position as the lookup value.

Syntax

=LOOKUP(lookup_value, lookup_vector, [result_vector])

Arguments

lookup_value – The value to look for in a single row or column

lookup_vector – The single row or column to search

result_vector – This is an optional argument. It is the single row or column range of results



Download



Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.