Wonderwall99

asked on

# MS Excel return value based on multiple criteria

MS Excel. I need a formula that returns the value in Column J (workbook #2) if the values in Column C2 & E2 (workbook#1) matches the same combination of values in Column A & C (workbook#2). I'll be using the solution on a larger set of data so the end result will be greater than just returning values for the combo of C2 & E2 (workbook#1)

Please do not use VBA for a solution, I'd like something more simple to edit later if needed.

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Open in new window