Hello,

Here's what I am trying to accomplish:

Sheet 1
Column A Column B
Row 1 A AA
Row 2 B BB
Row 3 C CC

Sheet 2
Column H Column J Column M
Row 1 A AA 150
Row 2 B BB 200
Row 3 A CC 300

I want the forumla to say:

If cell A1 in Sheet 1 appears anywhere in column H in Sheet 2, AND cell B1
in Sheet 1 appears anywhere in column J in Sheet 2, then give me the value
for it from column M in Sheet 2. Such a formula would return a result of 150.

Any help would be most appreciated. Thank you.