Maybe:-

=IF(ISNA(VLOOKUP(A1,B1:C3,2,FALSE)),"Not Found",VLOOKUP(A1,B1:C3,2,FALSE))

Mike

"Mahesh" wrote:

when ever we are using some lookup function, in case if there is no
corresponding value, we get #N/A

so let me know how to get rid of it