Hi all,

New to excel, having just started a office-based role and got to grips with VLOOKUP and then, even better XLOOKUP!

I look and find some solutions here on how to return more than 2 results from a data sets, though I'm not knowledgeable enough yet to apply to MY data set and needs unfortunately.

What I'm Trying to do


I want to pull Project Names from Column A of my DATA sheet, and populate my CALENDAR sheet under the appropriate date, which may exceed the 2 allowed by XLOOKUP.

Formulas I'm using currently to populate the CALENDAR:
1. =XLOOKUP(B$4,DATA!$E:$E,DATA!$A:$A,FALSE<>0)&""
2. =XLOOKUP(B$4,DATA!$E:$E,DATA!$A:$A,FALSE<>0,0,-1)&""

I'd attach screenshots, but as a new user unfortunately I can't (understandable). So i'll try explain via the formula

B$4 is the week (i.e 23)
DATA!$E:$E is the column including the date for each project
$A:$A is the Project name to pull through

Is there a way i can ensure it pulls through all projects so that I'm not restricted to 2?

I have toiled through many Youtube videos and forum posts all week, though couldn't quite apply what was explained for my purpose. Any help would be amazing!