Tables in the databases are much like worksheets or tables in Excel. Look at the Permit array of several tables box, and choose all of the tables. Then simply click OK.Queries a spread or an array and returns an merchandise corresponding on the to start with match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approx