Forum Discussion
Solved
How to use xlookup with condition
Hello, May I kindly check if anyone knows how to use XLOOKUP to achieve the specific requirement below? I would like to X-lookup only the value to the right of the bracket as shown in example bel...
I don't see what that has to do with XLOOKUP. You can use
=--MID(Table1[Study 1],FIND(")",Table1[Study 1])+1,100)
and
=--MID(Table1[Study 1],FIND("/",Table1[Study 1])+1,FIND(")",Table1[Study 1])-FIND("/",Table1[Study 1])-1)
I don't see what that has to do with XLOOKUP. You can use
=--MID(Table1[Study 1],FIND(")",Table1[Study 1])+1,100)
and
=--MID(Table1[Study 1],FIND("/",Table1[Study 1])+1,FIND(")",Table1[Study 1])-FIND("/",Table1[Study 1])-1)
Noted, thank you Hans!