excel computer course london - Lookup

Hi Michelle, Thank you for the post, in answer to your question, Lookup functions are used to extract a result from a table of data, to extract the information you will need to provide a lookup value (search criteria), this should be in a separate cell and should refer to a value or label from column/row 1 in the table, the Lookup function will then look for the intersection of this row or column with an indicated row or column, and will return the value or label. Lookups are either Vlookup or Hlookup, (Vertical or Horizontal). The syntax for a Vlookup table would then be; =VLOOKUP(Lookup_value,Database_cell_range,Column_to_search,Type_of_Lookup Type of lookup can be either TRUE or FALSE. If TRUE is indicated, the values must be sorted in ascending order, Lookup will then return the value equal to or less than the search criteria from the intersecting cell. I hope that helps, regards Pete.