Tables within a database are much like worksheets or tables in Excel. Look at the Empower variety of numerous tables box, and choose each of the tables. Then simply click OK.Searches a range or an array and returns an product corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate)