SOLVED

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)
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.

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