Forum Discussion
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 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
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)
2 Replies
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!
