V
vvaidya
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
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