How to use xlookup with condition

[AmyYang]

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 below. Or just the denominator number inside brackets.

I have been doing this task manually which is time-consuming so would love to know if there's a more efficient method through excel function.

Thank you,

Amy 

[#2 · Accepted solution]

@AmyYang 

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)

[#3]

Noted, thank you Hans!