Nov 23 2022 05:40 AM
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
Nov 23 2022 06:28 AM
SolutionI 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)
Nov 23 2022 06:28 AM
SolutionI 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)