Forum Discussion
MatthewSibley
Aug 31, 2022Copper Contributor
Help with match-insert.
I need a way to insert the expiration dates in column B into column E if the Task ID in column A matches the Task ID in column D. Columns A & B will change constantly (I'm doing this across multiple sheets, but if I can get a formula that will work I can just paste it into the other sheets.) I hope this makes sense. I deleted my previous post because it was confusing.
this can be done with a relatively simple XLOOKUP function.
=XLOOKUP(D2:D21,A2:A15,B2:B15,"")
2 Replies
Sort By
- dscheikeyBronze Contributor
this can be done with a relatively simple XLOOKUP function.
=XLOOKUP(D2:D21,A2:A15,B2:B15,"")
- MatthewSibleyCopper ContributorThat worked perfectly. You just saved me hours of copy and pasting!