Index infos in column based on row and column from other sheet

[alexxl]

Extract from data
* based on week column c
* matching row 1 from data.
* matching "Inbound calls answered" from data column C

desired results in collumn J


Mostra.xlsx

[AliGW]

No, alexxi - you need to give the details in your post as well. Do that NOW, please.

[sandy666]

is that what you want?
with Power Query

Week end	Week start	week	Month	Area	Service	KPI Type	KPI	Value
07/05/2023	01/05/2023	19	5	Enel	Inbound First Level	Contractual	Volumes	4383
30/04/2023	24/04/2023	18	4	Enel	Inbound First Level	Contractual	Volumes	2659

some of conditions are not described well
detailed description is required because it is ambiguous

[alexxl]

I preffer index and agregates cause power querry in this scenario is not my option. But also thank you is good to know!


detailed description is required because it is ambiguous

[Alex] i gaved you the way that i would extract by indexing (but i miss a link so i need help). So i think it`s enough for you to know and it seems that you gaved me a good answer based on this. Sorry if i was to short in description

[AliGW]

Where in the workbook have you mocked up what you want? SHOW us what we are aiming for.

EDIT: Forget that - found it.

[AliGW]

Try this:

=INDEX(Data!$D$2:$E$8,MATCH(LEFT(F3,FIND(" ",F3)-1)&"*",Data!$C$2:$C$8,0),MATCH(C3,Data!$D$1:$E$1,0))

[sandy666]

I preffer index and agregates cause power querry in this scenario is not my option. But also thank you is good to know!

sure, no problem
have a nice day

[alexxl]

Attachment 833680

Thank you always!

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.