Vlookup function error
 

Hello:
Would appreciate help with this one.

I am using a VLOOKUP function as follows:

Cell C1 contains the formula =VLOOKUP(A1,A2:B10,2,false)

Users enter a text value in Cell A1, I use the Vlookup function to look
up the text value in A1 against values in range A2:B10 & return the
corresponding value from the second column in the range.

This works well except then the user enters a text value in cell A1
which is not listed in range A2:A10. The vlookup function then returns
an error value = #N/A

Is there any way to suppress this error message by using a different
formula, or is there a different way of avoiding the error message

TIA

Vinay

Vlookup function error
 

Thanks a lot. Perfect solution!
Vinay