MaxSmith4Copper ContributorMar 06, 2020Matching Data I have 4 columns: A a set of numbers B a date that relates to that number D a set of numbers E a blank column what would be the formula that would check if: A matches D then put in E the da...Show MoreFormula.xlsx27 KB
MaxSmith4Copper ContributorMar 06, 2020Hello PReagan Thank you but this isn't what I am looking for,for example A3 may match to D23 etc. they arent always in the same row.
KashibabaBrass Contributor to MaxSmith4Mar 06, 2020This will work for you, enter this formula in E=INDEX($B:$D,MATCH(A3,$A:$A,FALSE),1)
