Vlookup function error

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
VBA Coding Help for Beginner 0
Transfer data between two tables 3
Code works on sheet but not from code-to-sheet 2
Need help to fix vlookup function in macro 1
Vlookup Function 1
Can I add a formula or function to Vlookup? 1
transformed vloopup 2

Top