Forum Discussion
Solved
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 ...
this can be done with a relatively simple XLOOKUP function.
=XLOOKUP(D2:D21,A2:A15,B2:B15,"")
this can be done with a relatively simple XLOOKUP function.
=XLOOKUP(D2:D21,A2:A15,B2:B15,"")
That worked perfectly. You just saved me hours of copy and pasting!