Condition meet this number of range

Hi i got some problem faced in excel
i want to use this
IPM602 as a condition where if it meet a condition then it display the company name else display other company name

IM602 is HTPORTS

So i wan meet a condition with a range of number if 1 of the number match it display the name

here the company name i have put
HTPORTS
CALLLADE
SEAFRONT
H SYSTEM
INDONSHIP
GKE
HOYSAN
H SYSTEM
HUATIONG
HUATIONGA

Number range start from IPM601 - IPM997

make a simple test excel

You dont really give us much to go on. I suggest that you upload a sample (dummy) file showing what you have, and what you want. Instructions for uploading a file are in the yellow banner above.

You can use this formula, where the search criteria is hard coded...
=VLOOKUP("imp602",$A$2:$B$61,2,0)

or use this 1 where the search criteria is entered into it's own cell (I used F3)...
=VLOOKUP(F3,$A$2:$B$61,2,0)