I currently have the following formula =XLOOKUP(R2,Lookupdata!J:J,Lookupdata!K:K," ",0,1) where if the Lookupdata tab range of J:J meets the criteria of R2 it returns "Hospital Based Program" and that if functioning correctly. My current situation is I have a list of people who should meet this criterion but due to circumstances they could fall into a different category and thus miss getting labeled "Hospital Based Program", so what I want to accomplish is adding in those specific names into the formula so if their name appears in the initial tab in column G that the cell with the formula will still populate "Hospital Based Program".