SOLVED

How to use xlookup with condition

Contributor

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.

 

AmyYang_0-1669210731279.png

Thank you,

Amy 

2 Replies
best response confirmed by AmyYang (Contributor)
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)

Noted, thank you Hans!