Creating a formula to check if combination of codes is available

[johanexcel]

Dear all,

I would like to request some help with creating a formula.

I have 1 data sheet with account numbers (column A) and departments (Column B). Not all account numbers are available with all departments.

Account	Department
4000	15
4000	16
4000	21
4001	15
4001	17
4001	20

<tbody>
</tbody>

In the input sheet (which will be completed manually) I would like to have a control to see if the combination of account number and department is a valid combination. What formula could I use?

Many thanks in advance for your expertise!

Johan

 

[Oeldere]

Book1
	A	B	C	D	E	F	G
1	Lookup table				INPUT DATA
2	Account	Department			Account	Department
3	4000	15	400015		4000	421	data not valid
4	4000	16	400016		4000	16
5	4000	21	400021		4000	21
6	4001	15	400115		4001	15
7	4001	17	400117		4001	17
8	4001	20	400120		4001	20
Blad12

Cell Formulas
Range	Formula
C3	=A3&B3
C4	=A4&B4
C5	=A5&B5
C6	=A6&B6
C7	=A7&B7
C8	=A8&B8
G3	=IFERROR(IF(MATCH(E3&F3,C3:C8,0)>0,"",),"data not valid")
G4	=IFERROR(IF(MATCH(E4&F4,C4:C9,0)>0,"",),"data not valid")
G5	=IFERROR(IF(MATCH(E5&F5,C5:C10,0)>0,"",),"data not valid")
G6	=IFERROR(IF(MATCH(E6&F6,C6:C11,0)>0,"",),"data not valid")
G7	=IFERROR(IF(MATCH(E7&F7,C7:C12,0)>0,"",),"data not valid")
G8	=IFERROR(IF(MATCH(E8&F8,C8:C13,0)>0,"",),"data not valid")