Vlookup or something else?

Hi,

You can use vlookup formula to fix this issue. The formula you can use is =IF(ISNA(VLOOKUP($F2,$B$2:$C$8,2,0))," ",VLOOKUP($F2,$B$2:$C$8,2,0)).

I've added ISNA to avoid NA erorr for blank cells. Please check the attached excel sheet.

Hope this helps.

Warm regards
Ishtiyaq