Multiplan's LOOKUP function allows you to retrieve a value from a table in another part of the worksheet.