Three Way Lookup

[Framboosje]

Hi,

i need your help guys.

I have difficulties with a three way lookup.
In sheet 2 is stated how much keys are per company and the dates.
In sheet 1 in cel B3 i want a formula that searchs in sheet2 for the right match of the company and date and give the number of keys.
i want this formula for all cells in sheet 1.

Kind regards,

Kareeem

[cbatrody]

Try the following array formula in B3:

=IFERROR(INDEX(Sheet2!$A$1:$C$183,MATCH($A3&B$2,Sheet2!$A$1:$A$183&Sheet2!$B$1:$B$183,0),3),"")

to be confirmed by pressing CTRL+SHIFT+ENTER

drag across and down the cells.

[Framboosje]

hi Cbatrody,

i tried it on the companies excel doc but it didn't work.
attached the doc that i use within the company

kind regards,

Kareem

[josephteh]

Adapt cbatrody's formula to as follow:

F6=IFERROR(INDEX(Blad1!$A$1:$D$183,MATCH($E6&F$5,Blad1!$A$1:$A$183&Blad1!$B$1:$B$183,0),4),"")

[kvsrinivasamurthy]

Try this, in F6 then drag down

=SUMPRODUCT((Blad1!$A$1:$A$183=$E6)*(Blad1!$B$1:$B$183=F$5)*(Blad1!$D$1:$D$183))