=IF(LOOKUP(LookupValue,$F$2:$F$100)=LookupValue,LO OKUP(LookupValue,$F$2:$G$100),"")

where F2:G100 is the lookup table, sorted on F2:F100 in ascending order,
will perform better than:

=VLOOKUP(LookupValue,$F$2:$G$100,2,0)

or

=IF(ISNA(VLOOKUP(LookupValue,$F$2:$G$100,2,0)),"", VLOOKUP(LookupValue,$F$2:$G$100,2,0))

Ragdyer wrote:
OP is looking for an exact match Aladin, as construed in the third line of
the OP.