I generated a formula to "spill" the 20 largest OT $ that exist across multiple pay periods (columns B to E). I have those 20 items listed in one column. I want to be able to able to return the address for those large OT $ items (those address exist in Column A). I can't seem to get a formula to return the address. Why would =Xmatch("OT amount",B3#) return a #VALUE error (where B3# is the spilled pay periods - columns B to E). I keep getting Xlookup errors that I can seem to evaluate to understand what I'm doing wrong. I thought this would be an easy formula, but I'm missing some key understanding of the new function Xlookup. Thank you.