Forum Discussion
Solved
I have a what IF question.
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
In 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.
- I think you are trying a LOOKUP function so in C5:
=XLOOKUP(B5:B74, A2:A1923, B2:B1923, "not found") In 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.
- Thank you!
