xlookup

[whynot]

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.

 

[Fluff]

You'd do that the same way as I showed you before

=XLOOKUP($A3&"|"&$B3,Sheet1!$A$2:$A$100&"|"&Sheet1!$B$2:$B$100,Sheet1!$G$2:$G$100,"",0)

 

[whynot]

Thank you - i am getting the following message - "VALUE"

I am using the following formula

=XLOOKUP($A3&"|"&$B3,US!$A$2:$A$1000&"|"&US!$B$2:$B$1000,US!$G$2:$G$100,"",0)

 

[whynot]

I figured it out.

thank you very much for your help!!!

Again, you saved me a ton of time!!

I really appreciate the help!!!

 

[Fluff]

You're welcome & thanks for the feedback.

 

[Peter_SSs]

If you are interested you could also use this approach.

=INDEX(FILTER(US!G$2:G$1000,(US!A$2:A$1000=A3)*(US!B$2:B$1000=B3),""),1)

 

[whynot]

Thank you very much for the reply.

I knew about Index function - not that i am very good at using it.

i did not know about the Filter function.

I will try to understand it better.

Thank you very much!!

I really appreciate the help.

 

[Peter_SSs]

You are very welcome. Thanks for the follow-up.

The FILTER function is another of the new functions in Excel 365, along with XLOOKUP (that you are obviously aware of) & several others.