#lookup function

[anil-dhawan-blog]

Learn two-way lookup trick in Microsoft Excel

[exceltutorials-blog]

Excel LOOKUP Function

In Excel, the LOOKUP function returns a value from a range (one row or one column) or from an array. The LOOKUP function has 2 different syntaxes, namely: vector and array

The LOOKUP vector syntax is Lookup(lookup_value,lookup_vector,result_vector). This form of LOOKUP looks in a one-row or one-column range for a value,then returns a value from the same position in a second one-row or one-column range.

here's the link to the complete tutorial