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
*J
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
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-
Check this...!
I worked out somethingBelieve in order...
Regards,
Solomon
On Mon, Jan 17, 2011 at 10:46 AM, jocky Beta 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 p
For contact person ur formula should be
=VLOOKUP($F$2,DATA!$B:$G,3,0)
And so on.
i.e instead of A it shoul start from B.as unique value is in col. B.
Hope it will haelp u.
On 17 January 2011 12:16, jocky Beta wrote:
>
> Hi,
>
> I made a Excel sheet with help of V lookup using the Data validat
Dear Jocky,
please find attached sheet..
Formula is here...
=IFERROR(VLOOKUP($F$2,DATA!$B$2:$G$8,3,0),"")
Thanks & regards,
Noorain Ansari
On Sun, Jan 16, 2011 at 11:33 PM, Manoj kumar <
manoj.vishwakarma...@gmail.com> wrote:
> Attached for ur reference
>
>
>
> Regards,
> Manoj Kumar
Attached for ur reference
Regards,
Manoj Kumar
On Mon, Jan 17, 2011 at 12:16 PM, jocky Beta 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.
>
>
>
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
