I am working on a spreadsheet that needs to show unique lot numbers from a reference sheet, but it needs to be tied to a date. For example, Lot 19-104 has data from August and September, so I need to have lot 19-104 returned twice, once for August and once for September. The reference sheet (Import Data) has a column for a date and a column for the lot number. The Production sheet has a column for the lot number and a column for the month. I can send a copy of the workbook so you can see what I'm working with (I can't see how to attach it here). Currently, I have just typed in the lot numbers and the date (month) comes in using xlookup using the lot number as a reference. I tried to bring the lot numbers in using UNIQUE, but I just get a spill error, even when I clear all the contents out of the column. The Import Data sheet is linked to an external data source.