Jan 12 2023 12:50 PM
I am in two sheets.
If B5:B74 in sheet 1 = A2:A1923 in sheet 2.
Say the word in the Column next to the matching A2:A1923 in sheet 2
Put it in sheet 1
Jan 12 2023 01:02 PM
SolutionIn a cell in row 5 on Sheet1:
=XLOOKUP(B2, 'Sheet 2'!$A$2:$A$1923, 'Sheet 2'!$B$2:$B$1923, "")
or if you have an older version of Excel:
=IFERROR(VLOOKUP(B2, 'Sheet 2'!$A$2:$B$1923, 2, FALSE), "")
Fill down to row 74.
Jan 12 2023 01:03 PM
Jan 12 2023 01:02 PM
SolutionIn a cell in row 5 on Sheet1:
=XLOOKUP(B2, 'Sheet 2'!$A$2:$A$1923, 'Sheet 2'!$B$2:$B$1923, "")
or if you have an older version of Excel:
=IFERROR(VLOOKUP(B2, 'Sheet 2'!$A$2:$B$1923, 2, FALSE), "")
Fill down to row 74.