Hi

VLOOKUP gives an exact match as follows =VLOOKUP(A1,B1:C200,2,0)