Excel
Anita Kulkarni (Student CA Final ) (166 Points)
29 December 2015Anita Kulkarni (Student CA Final ) (166 Points)
29 December 2015
Vishal Goel
(Chartered Accountant)
(1688 Points)
Replied 31 December 2015
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. ..