I have a what IF question.

New Contributor

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

3 Replies
best response confirmed by rrocha03 (New Contributor)


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")
Thank you!