Need help finding a formula that looks up 3 different criteria

[Jrish]

If 672 is column A, 15 is column B, and 9 is column C and so on... I need to be able to lookup 672, then look up area 55 in column B and return the number 22 in column C. Can someone help me with a formula for this? Thanks

672
15 9
16 15
17 15
18 3
24 1
25 3
26 2
41 12
46 3
47 16
48 26
55 22
71 39
76 16
83 1
Total For Store# 672 183

[shg]

Welcome to the board, Jrish.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.