User Profile
MovesMC
Copper Contributor
Joined May 19, 2022
User Widgets
Recent Discussions
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 search in a different sheet, match and return a value in a worksheet that matches. It works great for one data point. The first file, the contact ID shows up one time in column A. In the second file, it can show many times in Column A for each row that matches. In the first file, there is another criteria in Column H that needs to be matched to Column D values the second file, when these two match then return the value in File 2 into Column B in file 1. I cannot figure out how to do both criteria statements. File 1 - V Lookup Returns the ID from the second file but only the first instance of the matching field in column A Gift Import ID VLookUP Formula Fund ID 00001-545-0000100139 00001-553-0000103752 GIK Event 00001-545-0000100139 00001-553-0000103752 GIKFOOD 00001-545-0000100139 00001-553-0000103752 GIKHousehold File 2 I need to match both values in both files so that if the GFImpID and the GSSPlitFund match in both files then return the GSSplitImpID into the first file. GFImpID is a 1: MANY with GSplitImpID GFImpID GSplitImpID GSplitFund 00001-545-0000100139 00001-553-0000103752 GIK Event 00001-545-0000100139 00001-553-0000103751 GIKFOOD 00001-545-0000100139 00001-553-0000103753 GIKHousehold 00001-545-0000100140 00001-553-0000103755 GIK Event Thank you!911Views0likes1Comment
Recent Blog Articles
No content to show