If Names match on different tabs, enter data from 1st tab row/column into second tab.

[NGB82KS]

So I have 2 tabs 'Roster-Export' & 'Breakout'
The 'Roster-Export' tab is a complete listing of users, certifications, dates of completion etc..
The 'Breakout' tab is a bunch of formulas to break out certain info from the roster, surname, firstname, Mi etc...

I need to have a formula check for exact name matches on the 'Roster-Export' tab (Column A) against the 'Breakout' tab, name (Column J), and if there is a match, I need to to fill in (Column K) of the 'Breakout' tab with the text from 'Roster-Export' tab (Column I). Is this possible?

Example:
'Roster-Export' tab; Column A5 = "doe, john"; Column I5 = "20200201"
'Breakout' tab; Column J20 = "doe, john";
Because the names match, Column K of the 'Breakout' tab would display as "20200201".

 

[NGB82KS]

You

=IF( ISERROR(Index('Roster-Export'!I:I,Match('Breakout'!J20,'Roster-Export'!A:A,0))), "NO", IF(Index('Roster-Export'!I:I,Match('Breakout'!J20,'Roster-Export'!A:A,0))="TBD", "NO", "YES"))
Not the best way , as an OR() testing the #N/A still returns #N/A - must be a better way I will Think
OR
=IF( ISNA(Index('Roster-Export'!I:I,Match('Breakout'!J20,'Roster-Export'!A:A,0))), "NO", IF(Index('Roster-Export'!I:I,Match('Breakout'!J20,'Roster-Export'!A:A,0))="TBD", "NO", "YES"))

You and your wizard ball are once again correct. Thank you soooooooo much, this is literally going to save me hundreds of hours. My Roster export is 94812 rows long...! Thank you again!!!!

 

[etaf]

you are very welcome
Not seen a better way yet, BUT other members may possibly reply with alternative