On Sheet 2 in cell L2 I am trying to create a formula that will return the text from Sheet 1 Column B, based on if the text in cell L2 is within that range. I am open to any formula that may do this. As you can see I used a sequence formula on sheet 1 to expand my range, I then attempted to use a xlookup on Sheet 2, and get a value error. Please help me fix my value error, or suggest a new formula! There are approximately 1000 rows where I will using this, thank you!!!