Excel Lookups: Power Bite Webinar
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.