----------------------------------------------------------------------------------------------------------------------------
Hi Prabhat,
Assumption: X denotes a Vlookup formula like this X = VLOOKUP(A1,A:B,
2,0).
Solution: Use this formula IF(ISERROR(X),"",X)
Description: Since #NA denotes the error(coz. Value not found),
ISERROR detects the
error and returns TRUE(if #NA occurs) or FALSE(if
no error occurred). Now
the return value of ISERROR formula is passed to
IF. So if an error as occurred,
it will display nothing (due to "") but if no error
is occurred then it will display
the actual value as returned by the VLOOKUP
formula.
Example: =IF(ISERROR(VLOOKUP(A1,A:B,2,0)),"",VLOOKUP(A1,A:B,2,0))
For more tips, tricks, tutorials (Charts, Formulas and Macros),
Downloads(Add-ins and Utilites) and
Problem/Query solutions: visit --> http://www.excelitems.com
------------------------------------------------------------------------
Regards
Ashish Jain
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author -> www.excelitems.com
09999-40-48-43
----------------------------------------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------------------------------------------
On Feb 25, 10:16 pm, "prabhat.shrivasta...@gmail.com"
<prabhat.shrivasta...@gmail.com> wrote:
> Dear All,
>
> Pls help me out to avoid NA# error while there is no value found by
> Vlookup. let suppose
> if there is in a cloumn i did not found any value in define range than
> result would come as NA#. Now i want get the result other than NA# or
> result define by me.
>
> Thanks and Regrds
> Prabhat Shrivastava
> HDFC Bank
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
