Comparing and Returning Results

[dgaines]

Hello, I'm needing help creating a syntax for the following scenario. I have two sheets in an Excel file. I'm wanting to take column A from Sheet2 and see if there are any matches in column B of Sheet1, then if there is a match(or same containing character sequence) then return value "retired" to column H on Sheet1. If there is no match then just leave it blank. Thanks.

 

[JoeMo]

If you want exact matches, assuming you have headers in row 1 of both sheets, enter in H2 of Sheet1 and copy down to the end of Sheet1, col B data:

=IF(ISNA(MATCH(B2,Sheet2!$A$2:$A$100,0)),"","retired")

Change the row in bold red to suit the extent of your data in Sheet2.

 

[dgaines]

If you want exact matches, assuming you have headers in row 1 of both sheets, enter in H2 of Sheet1 and copy down to the end of Sheet1, col B data:

=IF(ISNA(MATCH(B2,Sheet2!$A$2:$A$100,0)),"","retired")

Change the row in bold red to suit the extent of your data in Sheet2.

Thanks for the reply, it's not throwing any errors but i don't see any matches hitting. And it doesn't have be to an exact match or even on the same row. For instance if row 7 from Sheet2 has "123456" id like for it detect a match say on Sheet1 row 3 with "ABC123456", and then throw a "retired" on row 3, column H on Sheet1.

 

[JoeMo]

Thanks for the reply, it's not throwing any errors but i don't see any matches hitting. And it doesn't have be to an exact match or even on the same row. For instance if row 7 from Sheet2 has "123456" id like for it detect a match say on Sheet1 row 3 with "ABC123456", and then throw a "retired" on row 3, column H on Sheet1.

As I said in my post, the formula I provided is for Exact Matches.

Try searching this forum for "fuzzy matches".