I have a what IF question.

[rrocha03]

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

[#2 · Accepted solution]

@rrocha03

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.

[#3]

I think you are trying a LOOKUP function so in C5:
=XLOOKUP(B5:B74, A2:A1923, B2:B1923, "not found")

[#4]

Thank you!