force to use VLOOKUP ... :-)

Sheet1!E1:
{=IF(ISNA(VLOOKUP(A1&"M",Sheet2!$A$1:$A$3&Sheet2!$ E$1:$E$3,1,0)),"","M")}
Sheet1!F1:
{=IF(ISNA(VLOOKUP(A1&"F",Sheet2!$A$1:$A$3&Sheet2!$ E$1:$E$3,1,0)),"","F")}

and copy down


"p45cal" wrote in message ...

It may not as easy as that, Vlookup will return only 1 result.