Multiple criteria search

[Framboosje]

Hi,

i need your help guys.

I have difficulties with a three way lookup.
I want in the sheet dataimport the result of presented calls based on the company and the date

Kind regards,

Hadi

[CK76]

=IFERROR(INDEX(Table_Data[Total Calls Presented],MATCH($E6&F$5,Table_Data[Report date]&Table_Data[Company],0)),"")

Confirmed as Array (CTRL + SHIFT + ENTER)

Though, personally, I'd use Pivot Table and/or PowerQuery.

See attached.

[Framboosje]

Thanks a lot!!

last question: i want always a 0 if there is nog result

[shukla.ankur281190]

Try

Please Login or Register  to view this content.