Avatar of Wonderwall99
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.

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
byundt

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
byundt

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
byundt

If you find the recalc time annoying when you copy the suggested formula down, please consider building an auxiliary column that concatenates the values in Workbook 2 columns A and C. Assuming this concatenation is in column Z, you may then use an INDEX & MATCH formula like:
=IFNA(INDEX('[Workbook 2.xlsx]Sheet1'!J$2:J$10000, MATCH(C2 & E2,'[Workbook 2.xlsx]Sheet1'!Z$2:Z$10000,0)), "Not found")

Open in new window

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck