Forum Discussion

MovesMC's avatar
MovesMC
Copper Contributor
May 19, 2022

Match Two Criteria in Two DIFFERENT Spreadsheets NOT in Column 1, return lookup value

=IF(ISNA(MATCH(A2,'FY2122 Split Gifts to Reconfigure 5.19.2022.csv'!$A:$A,0)),"",VLOOKUP(A2,'FY2122 Split Gifts to Reconfigure 5.19.2022.csv'!$A:$G,2,FALSE))   I am using the above formula to searc...
excel
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
May 19, 2022

MovesMC 

=VLOOKUP(A2&C2,CHOOSE({1,2},'FY2122 Split Gifts'!$A$2:$A$5&'FY2122 Split Gifts'!$C$2:$C$5,'FY2122 Split Gifts'!$B$2:$B$5),2,0)

Maybe with this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.