Forum Discussion
Create an Excel formula that has conditional & lookup arguments in 2 workbooks
Abraham M. Payton Jr. Took your question literally and created a mock-up of the situation that I believe you described. Attached two workbooks including a rather ugly formula in A1 of Workbook A.
=IFERROR(IF(ISNUMBER(MATCH(C3,'[Workbook B.xlsx]Sheet1'!$A$1:$A$16,0)),INDEX('[Workbook B.xlsx]Sheet1'!$A$11:$CF$11,1,MATCH(A11,'[Workbook B.xlsx]Sheet1'!$A$4:$CF$4,0)),""),"")Open both workbooks at the same time and you should be able to test it.
Very likely, though, that there are better ways to do this, but for that you would have to share the real workbooks A and B. Replace any confidential information with fake data, if you should decide to do so.
Abraham M. Payton Jr. Took your question literally and created a mock-up of the situation that I believe you described. Attached two workbooks including a rather ugly formula in A1 of Workbook A.
=IFERROR(IF(ISNUMBER(MATCH(C3,'[Workbook B.xlsx]Sheet1'!$A$1:$A$16,0)),INDEX('[Workbook B.xlsx]Sheet1'!$A$11:$CF$11,1,MATCH(A11,'[Workbook B.xlsx]Sheet1'!$A$4:$CF$4,0)),""),"")Open both workbooks at the same time and you should be able to test it.
Very likely, though, that there are better ways to do this, but for that you would have to share the real workbooks A and B. Replace any confidential information with fake data, if you should decide to do so.
Riny_van_Eekelen Thank you so very much. This works just like I wanted it to. I apologize if I confused the problem by not providing the information in a way that made it easy for you to help me. Again, thank you!