Short session on this useful Excel feature
This is an online webinar for students who are unable to attend the face-to-face classes at the Edinburgh Campus Library, You will be emailed the webinar URL prior to the Power Hour. Please note the time is British time.
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 valued don't need to be repeated throughout the spreadsheet. This significantly reduces data maintenance issues.