I have this formula to tell me the number of a school , when I put part of the name in G2.
Number is in E, school in F.
I need it to tell me if there is more than 1 if possible. ie I have Schoolname Infant, Schoolname Junior, Schoolname High. At the moment it is giving me the first one.
=XLOOKUP(G2&"*",F2:F500,E2:E500,,2)
Thank you
Number is in E, school in F.
I need it to tell me if there is more than 1 if possible. ie I have Schoolname Infant, Schoolname Junior, Schoolname High. At the moment it is giving me the first one.
=XLOOKUP(G2&"*",F2:F500,E2:E500,,2)
Thank you