Show Sale of Town A or etc from 1 sheet to another sheet

[smyle]

Dear Experts, i have 2 sheets, in 1 sheet we have different town sale and in 2nd sheet how can i put these sale into their column. please help me in this.

Sheet 1

SAPCODE	Code	SKUName	ID	SKUID	Opening Stock	Receipt	Purchase Return	MTD Issued	SReturn	CStock	A	K	Z
123		Pencil			10	5				11	2	1	1
456		Paper			10	5				11	2	1	1
789		Cup			10	5				2	3	4	6
1122		Scale			10	5				6	2	2	5
3344		Sharpner			10	5				6	3	1	5
5566		Cutter			10	5				3	3	0	9
7788		Gum Stick			10	5				3	10	1	1

<colgroup><col><col><col><col span="7"><col><col span="3"></colgroup><tbody>
</tbody>

Sheet 2

Opening Stock

Received From Company

Recevied From Others

Town List

Town List

Town List

Town List

Sku Code

SKU

Cases

Cases

Cases

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

X

Y

Z

123

Pencil

10

5

456

Paper

10

5

789

Cup

10

5

1122

Scale

10

5

3344

Sharpner

10

5

5566

Cutter

10

5

7788

Gum Stick

10

5

<colgroup><col><col><col><col><col><col span="26"></colgroup><tbody>
</tbody>

 

[DHayes]

Hi,
copy this into sheet 2 under town A and copy down and across.

=IFERROR(SUMPRODUCT(--((Sheet1!$A$2:$A$8=Sheet2!$A3)*(Sheet1!$C$2:$C$8=Sheet2!$B3)*(Sheet1!$L$1:$N$1=Sheet2!F$2)),Sheet1!$L$2:$N$8),0)