Forum Discussion
Consolidate/Merge Data in Multiple Files
You can use XLOOKUP for this purpose.
Let's say the sheet with the completed comments is named Other Sheet, with tag numbers in B2:B100 and comments in D2:D100.
On the sheet without comments, let's say the tag numbers are in C2:C50.
In the comment column, enter the following formula in row 2:
=XLOOKUP(C2:C50, 'Other Sheet'!B2:B100, 'Other Sheet'!D2:D100, "")
This will automatically spill its results to rows 2 to 50.
You can use XLOOKUP for this purpose.
Let's say the sheet with the completed comments is named Other Sheet, with tag numbers in B2:B100 and comments in D2:D100.
On the sheet without comments, let's say the tag numbers are in C2:C50.
In the comment column, enter the following formula in row 2:
=XLOOKUP(C2:C50, 'Other Sheet'!B2:B100, 'Other Sheet'!D2:D100, "")
This will automatically spill its results to rows 2 to 50.
I am getting a #SPILL! error. What am I doing wrong?
The formula should be entered in one cell only, and the cells below it should be empty.
