Am i able to use the XLOOKUP function to perform the following task.
I need the value that matches year and week in my output sheet from the data i have in another sheet.
See screenshots below
My output sheet - Column C would is output column and I need to fill that column with data from the sheet below if it matches year and week.
My data sheet - Need to pull the values from column G
Thank you in advance for your help.
I need the value that matches year and week in my output sheet from the data i have in another sheet.
See screenshots below
My output sheet - Column C would is output column and I need to fill that column with data from the sheet below if it matches year and week.
My data sheet - Need to pull the values from column G
Thank you in advance for your help.