VLookup Worksheet Function - LQ Excel

=VLookup( Lookup_Value, Table_Range, Column_Number, [Approx or Exact]) VLOOKUP finds the data in a specific row and column within a table of data. It looks for a given value in the first column of the table and then retrieves values from other columns in

www.lqexcel.com