Formula

  • Thread starter Thread starter Steved
  • Start date Start date
S

Steved

Hello from Steved
I'm Thinking SUMPRODUCT
INDEX(A13:B13,C2:C29,3,Sheet1!A4:C27).

I've Sheet1 and Sheet2
I would like to get the value from Sheet1 (C4 21524)

On Sheet2 A13 = 305
On Sheet2 B13 = S
On Sheet2 C13 = the Value from Sheet1

On Sheet1 A4 is 305
On Sheet1 B4 is S
On Sheet1 C4 is 21524
What do I have to do as it returns an 0 value.

Thanks in Advance
 
I worked it out, it is not a Index formula.

SUMPRODUCT(--(Sheet1!$A$2:$A$28=A13),--(Sheet1!
$B$2:$B$28=B13),Sheet1!$D$2:$D$28)

Thanks
 
Back
Top