Excel

179 views 1 replies
User Avatar

Student CA Final
166 Points Joined September 2015
hello, can anyone tell me how to remove the #N/A error in a spreadsheet while using the vlookup function.,or what care needs to be taken to avoid such errors while using lookup function.
0 Reply Share Follow
On 29 December 2015 at 20:24 Report
Replies (1)
User Avatar

Chartered Accountant
1693 Points Joined April 2014

Hello, 

Use IFERROR function with vloopup like

=IFERROR(VLOOKUP(lookup_value,table_array,Coloum_index_num,0),"incorrect name")

If you use iferror function then it will not show #N/A.. ........In my example it will show incorrect name. ..

Reply
On 31 December 2015 at 15:41


CCI Pro

Leave a Reply

Post Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Recent Threads

More recent discussions | Post

Related Threads
Loading