compare to list --like a Vlookup?

[poker]

worksheet data entry column J which is a dynamic length there are numbers that identify product code. On worksheet called info in column cg2:cg41 is a set range of numbers. on worksheet called data i would like to look in column J2 and see if it matchs a value on sheet info cg2:cg41, if yes fill in cell with "Vapor" I gave the range cg2:cg41 a name called vapor_list
=VLOOKUP(J2,VAPOR_LIST,1,FALSE)

 

[Aladin Akyurek]

worksheet data entry column J which is a dynamic length there are numbers that identify product code. On worksheet called info in column cg2:cg41 is a set range of numbers. on worksheet called data i would like to look in column J2 and see if it matchs a value on sheet info cg2:cg41, if yes fill in cell with "Vapor" I gave the range cg2:cg41 a name called vapor_list
=VLOOKUP(J2,VAPOR_LIST,1,FALSE)

=IF(ISNUMBER(MATCH(J2,VAPOR_LIST,0)),"Vapor","Not Found")

or

=ISNUMBER(MATCH(J2,VAPOR_LIST,0))+0

Custom format the formula cell as:

[=0]"Not Found";[=1]"Vapor"

 

[poker]

Thanks for the response