Lookup and Reference Functions in Excel.
Lookup functions are frequently used to get data from a table and use it in another area of the Work Sheet or Workbook. They are often equivalent to a set of multivalued IF functions. We’ll focus on two key lookup routines this year: using VLOOKUP and HLOOKUP Reference functions return text values that contain information …
