pic : Google Spreadsheet

(You need to see the image, so you will know what I mean, hopefully)

I have some testcase that I want to try, how can I get the "yess" in C3. My logic condition to get that was if A column is "a" and then check each of "a" in B column that has "3" then return the C so we can get the "yess" value. But I am stuck at implementing using VLOOKUP, HLOOKUP and XLOOKUP. Any ideas?

When I tried xlookup, with no combination its only return the first of "a"

CodePudding user response：

Use FILTER :