May 19 2022 01:33 PM
=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!
May 19 2022 01:44 PM
=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.