Forum Discussion
auto fill text cell based on text of another
Hello, Is there a way to automatically fill each cell of column1A of sheet1 based on the text on column1B cells of the same sheet1 according to the equivalent pair of cells from another sheet2? To ...
In A2 on Sheet1:
=XLOOKUP(B2, 'Sheet2'!B:B, 'Sheet2'!A:A, "")
Replace Sheet2 with the real name of the second sheet.
Fill down as far as you want.
