SOLVED

# I have a what IF question.

Copper Contributor

# 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

3 Replies
best response confirmed by rrocha03 (Copper Contributor)
Solution

# Re: I have a what IF question.

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

# Re: I have a what IF question.

I think you are trying a LOOKUP function so in C5:

# Re: I have a what IF question.

Thank you!
1 best response

Accepted Solutions
best response confirmed by rrocha03 (Copper Contributor)
Solution

# Re: I have a what IF question.

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