Forum Discussion

Copper Contributor

Aug 31, 2022

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 ...

excel

dscheikey
Aug 31, 2022
HiMatthewSibley,
this can be done with a relatively simple XLOOKUP function.
=XLOOKUP(D2:D21,A2:A15,B2:B15,"")
match-insert.xlsx10 KB

dscheikey

Bronze Contributor

Aug 31, 2022

HiMatthewSibley,

this can be done with a relatively simple XLOOKUP function.

=XLOOKUP(D2:D21,A2:A15,B2:B15,"")

match-insert.xlsx10 KB

MatthewSibley
Copper Contributor
Aug 31, 2022
That worked perfectly. You just saved me hours of copy and pasting!