LinkBack URL
About LinkBacks
Hi
One error is coming in my data as per attached excel sheet, due to this I am unable to use Vlookup formula. so will any one suggest how to remove that green color error.
How to remove Error
Hi
One error is coming in my data as per attached excel sheet, due to this I am unable to use Vlookup formula. so will any one suggest how to remove that green color error.
There's no error in your workbook...can you make a sample and post it again?
"The quieter you become, the more you are able to hear"
Any reputation (*) points appreciated.
"If you know yourself but not the enemy, for every victory gained, you will suffer defeat."
Your sheet contain only one formula which is =RIGHT(A2,5). This extracts 5 digits number from right of the string in A2. As a result the number in col. B is a number stored as text so you can not use it as it is if the lookup column in Vlookup contain real numbers not numbers stored as text (though there are possible adjustment in the Vlookup formula to deal with this kind of situation).
So if you want these extracted numbers as real numbers you may try this.....
If this is not what you are trying to achieve, please be more specific about the error you are talking about.
=RIGHT(A2,5)+0
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Hi sktneer,
Thanks for your help, excatly I am searching that one.
Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks