Vlookup alternative

[ROHAN999]

Sir

i am using vlookup(i12,j5:j50000,9,0)

but when it does not find data it gives #n/a

what formula should i use so that if my i column value is not there in column j

then it return a value *

kindly guide

[Ace_XL]

=IF(ISERROR(VLOOKUP(I12,J5:J50000,9,0)),"*",VLOOKUP(I12,J5:J50000,9,0))

or for later than 2003 versions
=IFERROR(VLOOKUP(I12,J5:J50000,9,0),"*")