Find Data in Columns or Rows with Excel's LOOKUP Function
The Vector form of Excel's LOOKUP function can be used to find a single value from a one-row or one-column range of data. A step by step example of using the vector form of the LOOKUP function is included with this tutorial....