F
Fgbdrum
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.
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.