Hi Team,
I got the Point _
But one more Question is in my Data Sheet their is Two Phone numbers are
saved in F6 when it results in Main Data sheet its shows the Question mark
between the ph no, I want to ask is their any way to arreng the same like
F6. i.e one under one?????
Regards
*Jocky*
On Tue, Jan 18, 2011 at 11:07 AM, Manoj kumar <
manoj.vishwakarma...@gmail.com> wrote:
> Hi Jocky,
>
> The reason you are getting #NA error because your criteria for "*
> table_array"* * * (*This is the table of data that VLOOKUP searches to
> find the information you are after.*) is wrong. Your range should start
> from column B and not A because "the value you want to find in the B column
> of the table.
>
> And I think this is the only mistake u have made in the formula....
>
> Some links :-
>
> http://www.timeatlas.com/5_minute_tips/general/learning_vlookup_in_excel
> http://www.techonthenet.com/excel/formulas/vlookup.php
>
>
> I think this help u out....
>
>
>
> Regards,
> Manoj Kumar
>
>
> On Mon, Jan 17, 2011 at 8:40 PM, jocky Beta <jocky6...@gmail.com> wrote:
>
>>
>> Hi Manoj,
>>
>> Thanks for the Information, But when i individually insert range_lookup
>> value 0 it shows #NA value in contact person, Hence i request you to please
>> give me the Step by step details from starting to do the Same(from how to
>> make drag drop list to Last one)
>>
>> Looking foreword for your co-operation.
>>
>>
>> *Please Help me for the above Query!!!!!!!!!!!!!!! *
>> *
>> *
>> *
>> *
>> *Thanks *
>> *Jocky
>> *
>>
>> On Mon, Jan 17, 2011 at 1:03 PM, Manoj kumar <
>> manoj.vishwakarma...@gmail.com> wrote:
>>
>>> Attached for ur reference....
>>>
>>>
>>>
>>> Regards,
>>> Manoj Kumar
>>>
>>>
>>> On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta <jocky6...@gmail.com>wrote:
>>>
>>>>
>>>> Hi,
>>>>
>>>> I made a Excel sheet with help of V lookup using the Data validation,
>>>> but my formula shows unknown error. hence pls explain me the step by
>>>> step procedure for the same.
>>>>
>>>>
>>>> Regards
>>>> Jocky
>>>>
>>>> --
>>>>
>>>> ----------------------------------------------------------------------------------
>>>> Some important links for excel users:
>>>> 1. Follow us on TWITTER for tips tricks and links :
>>>> http://twitter.com/exceldailytip
>>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>>
>>>> To post to this group, send email to excel-macros@googlegroups.com
>>>>
>>>> <><><><><><><><><><><><><><><><><><><><><><>
>>>> Like our page on facebook , Just follow below link
>>>> http://www.facebook.com/discussexcel
>>>>
>>>
>>>
>>
>> --
>>
>> ----------------------------------------------------------------------------------
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
