I want to use a formula that looks for a value in another worksheet and returns a specific value that I choose if it finds it and a different value I choose if it doesn't, rather than TRUE/FALSE. I think the formula would be combining IF and XMATCH, but I'm not sure.
In the spreadsheet attached I want this formula to be applied to worksheet 1 column c, looking for the value in column b against worksheet 2, column b.
If it finds the value it should return "Has Subscription".
If it doesn't, it should return "No Subscription".
Bookmarks