Forum Discussion
Solved
Excel for Mac Xlookup
Hi All, I am new to Excel and have been trying to analyse some data to build a Dashboard and i have so far learnt about SumIf and Xlookup but I have hit a road block where all is get as a result ...
Hi
Not sure this is exactly what you want. If not please upload a picture of what you have and what you expect
in E2
=XLOOKUP(E1,A1:A2,B1:B2, XLOOKUP("*" & E1 & "*",A1:A2,B1:B2,,2),0)which means: If an exact match of value in E1 can't be found in A1:A2, do another XLOOKUP with wildcards
Hi
Not sure this is exactly what you want. If not please upload a picture of what you have and what you expect
in E2
=XLOOKUP(E1,A1:A2,B1:B2, XLOOKUP("*" & E1 & "*",A1:A2,B1:B2,,2),0)which means: If an exact match of value in E1 can't be found in A1:A2, do another XLOOKUP with wildcards
Thank you will give it a try