Menu
Excel
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.
Replies (1)
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. ..
Recent Topic
- Business income source for husband and wife
- Set off of LTCL against STCG under section 536(2n)
- Audit Workflow tool
- Is CA through direct entry easy for a commerce stu
- Dividend and withholding tax - DTAA- RSU
- NRI Query: Capital Gains Tax Exemption under Secti
- Royalty payment to UK
- Calculate ITR2 tax with equity and non equity prof
- LTCG on residential property sale - Rebate?
- TDS MISMATCH AND AIS
Related Topics
CAclubindia
