I have issues when dealing with the IF function (to sure it should be IF or
PRODUCT):

A,H,J,M are text cells and C= to number cells

when
(H1:H1000=J1) AND (A1:A1000=M1) Then C1='1000-1'
(H1:H1000=J1) AND (A1:A1000=M2) Then C1='1000-2'
(H1:H1000=J1) AND (A1:A1000=M3) Then C1='1000-3'
(H1:H1000=J1) AND (A1:A1000=M4) Then C1='1000-4'

(H1:H1000=J2) AND (A1:A1000=M1) Then C1='2000-1'
(H1:H1000=J2) AND (A1:A1000=M2) Then C1='2000-2'
(H1:H1000=J2) AND (A1:A1000=M3) Then C1='2000-3'
(H1:H1000=J2) AND (A1:A1000=M4) Then C1='2000-4'

(H1:H1000=J3) AND (A1:A1000=M1) Then C1='3000-1'
(H1:H1000=J3) AND (A1:A1000=M2) Then C1='3000-2'
(H1:H1000=J3) AND (A1:A1000=M3) Then C1='3000-3'
(H1:H1000=J3) AND (A1:A1000=M4) Then C1='3000-4'


help please?