@Christiaan_Huizer Your formula would work if I was able to create a column in the Lookup table with your formula. Unfortunately, I currently am not able to add a column to the table as I am pasting new data over the table when the source data is updated from a spreadsheet. I know the way I have this table and the lookup of it set up is not right. I am working on solving that problem separately in the post linked below.