Excel Lookups: Power Bite (Category: Information Technology)
Short session on this useful Excel feature
Lookups are functions which allow a given value to be looked up from within a table and an alternative column to be returned from that table. It can also return the closest match to the value being looked up so that each row in the table can represent ranges of values. Benefits are enhanced presentation and tables of values don't need to be repeated throughout the spreadsheet, significantly reducing spare data maintenance issues.
- Friday, October 20, 2017
- 14:30 - 15:00
- Library Teaching Room, Edinburgh Campus Library
- Edinburgh Campus