How not to show #N/A when using vlookup formula
I have a vlookup formula =vlookup(V3,SHEET1!,$G$3:$J$14520,4,0) which I have
inputed. Many of the responses come back with #N/A. I would like to remove this. Using IF(V3="","", does not work, becasue there is data there. What do I need to add to my formula? -- Thanks in advance, inthestand |
How not to show #N/A when using vlookup formula
=IF(ISNA(YourFormula),"",YourFormula)
-- Kind regards, Niek Otten "inthestands" wrote in message ... I have a vlookup formula =vlookup(V3,SHEET1!,$G$3:$J$14520,4,0) which I have inputed. Many of the responses come back with #N/A. I would like to remove this. Using IF(V3="","", does not work, becasue there is data there. What do I need to add to my formula? -- Thanks in advance, inthestand |
How not to show #N/A when using vlookup formula
You have to add an if statement
=if(iserror(vlookup(V3,SHEET1!,$G$3:$J$14520,4,0)) ,"No Data",vlookup(V3,SHEET1!,$G$3:$J$14520,4,0)) Hope it helps "inthestands" wrote: I have a vlookup formula =vlookup(V3,SHEET1!,$G$3:$J$14520,4,0) which I have inputed. Many of the responses come back with #N/A. I would like to remove this. Using IF(V3="","", does not work, becasue there is data there. What do I need to add to my formula? -- Thanks in advance, inthestand |
All times are GMT +1. The time now is 04:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com