You can us VLOOKUP to reference lookup tables on other worksheets and in other workbooks adding to the power and adaptability of this lookup function.
Highlights
- Build a VLOOKUP formula with the Insert Function Wizard
- Connect VLOOKUP to a lookup table in an external workbook
- Understand the automatic application of absolute references to external lookup links