Tables within a databases are similar to worksheets or tables in Excel. Test the Allow number of numerous tables box, and choose all of the tables. Then click on Alright.Searches a range or an array and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match.