Vlookup or If/Then to return a substitute cell for a cell that matches itself in a range

Shadefalcon,

Attached is a modified version of example book 2.

In sheet 'Table 1' cell B2 and copied down is this array formula:

=IF(COUNTIF('Table 2'!$A$2:$E$15,A2)=0,"",INDEX('Table 2'!A:A,MIN(IF('Table 2'!$A$2:$E$15=A2,ROW('Table 2'!$B$2:$E$15)))))

Note that array formulas must be entered with Ctrl+Shift+Enter and not just Enter. That's how they get the curly braces {}. Do not try to add those yourself.