Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
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.comwrote: 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
Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
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 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 -- Thanks regards, Noorain Ansari -- -- 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 formula(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
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 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 -- Regards, Sandeep Kumar Chhajer. Ph. no: 07498171901 09339549906 Wish you all happy new Year 2011. -- -- 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
Fwd: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
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
Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
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
$$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
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 formula.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ need Formula Correction !!!!!!!!!!!!!
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 GG - Vlookup_Manoj.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet