## How to use Excel LOOKUP function

Introduction LOOKUP function in excel is a lookup and reference function. This function is used to lookup or approximately match data in single column or single row and retrieve value from corresponding column or row. This function has two forms, one is called vector and the other one is called array form. Vector form Syntax =LOOKUP(Lookup_Value, Lookup_Vector, [Result_Vector]) Vector form Argument Lookup_Value: Value that will be searched in the first vector. Can be text, number, reference etc.Lookup_Vector: It is the…