=IFERROR(VLOOKUP(A2,'column1 data'!A:B,2,0),"") Regards, Kuldeep Singh
On Wed, Aug 22, 2012 at 5:29 PM, Rakesh Kumar Sharma <rakeshks....@gmail.com > wrote: > Hi Noorain, > > If i want to pick data of column2 then how it works? > > See attachment. > > > On Fri, Aug 17, 2012 at 4:33 PM, NOORAIN ANSARI > <noorain.ans...@gmail.com>wrote: > >> Dear Rakesh, >> >> See attached sheet. >> >> >> On Fri, Aug 17, 2012 at 4:13 PM, Rakesh Kumar Sharma < >> rakeshks....@gmail.com> wrote: >> >>> Hi Noorain, >>> As you told to use INDEX & MATCH to replace VLOOKUP . >>> plz find the attached file & share how to use these >>> >>> >>> On Thu, Aug 16, 2012 at 6:11 PM, Rakesh Kumar Sharma < >>> rakeshks....@gmail.com> wrote: >>> >>>> Dear Noorain/ Amresh, >>>> >>>> >>>> Thank u so much for great helping. >>>> >>>> >>>> >>>> On Thu, Aug 16, 2012 at 4:21 PM, NOORAIN ANSARI < >>>> noorain.ans...@gmail.com> wrote: >>>> >>>>> Dear Rakesh, >>>>> >>>>> You can also set high priority of Excel exe file >>>>> See attached screen shot. >>>>> >>>>> >>>>> On Thu, Aug 16, 2012 at 4:15 PM, NOORAIN ANSARI < >>>>> noorain.ans...@gmail.com> wrote: >>>>> >>>>>> Dear Rakesh, >>>>>> >>>>>> You can do the following to speed up your workbook. >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> 1). Save your file in .xlsb (Binary Format) to reduce size. >>>>>> >>>>>> 2).Remove unnecessary formatting. >>>>>> >>>>>> 3) Use Index Match instead of Vlookup() >>>>>> >>>>>> 4).Set Calculation Manual (Calculate only when required) >>>>>> >>>>>> 5).Use Name Ranges. >>>>>> 6).Sort your data >>>>>> >>>>>> >>>>>> -- >>>>>> With Regards, >>>>>> Noorain Ansari >>>>>> http:// >>>>>> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> >>>>>> http:// >>>>>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com> >>>>>> >>>>>> >>>>>> On Thu, Aug 16, 2012 at 1:01 PM, Rakesh Kumar Sharma < >>>>>> rakeshks....@gmail.com> wrote: >>>>>> >>>>>>> Hi Experts, >>>>>>> >>>>>>> I have a sheet of 70MB. I am facing problem when using formulas & >>>>>>> filters. It gets slow. I am using Excel 2010. Is there any way to >>>>>>> prevent >>>>>>> to being slow process or any format where i can work on a reduced file >>>>>>> size. >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Regards, >>>>>>> >>>>>>> Rakesh Kumar Sharma >>>>>>> Contact: +91-9971024741 >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> Join official facebook page of this forum @ >>>>>>> https://www.facebook.com/discussexcel >>>>>>> >>>>>>> FORUM RULES (1120+ members already BANNED for violation) >>>>>>> >>>>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>>>> Advice will not get quick attention or may not be answered. >>>>>>> >>>>>>> 2) Don't post a question in the thread of another member. >>>>>>> >>>>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>>>> measure. >>>>>>> >>>>>>> 4) Acknowledge the responses you receive, good or bad. >>>>>>> >>>>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>>>> in signatures are prohibited. >>>>>>> >>>>>>> 6) Jobs posting is not allowed. >>>>>>> >>>>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >>>>>>> allowed. >>>>>>> >>>>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>>>> Forum owners and members are not responsible for any loss. >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>>>> To unsubscribe from this group, send email to >>>>>>> excel-macros+unsubscr...@googlegroups.com. >>>>>>> >>>>>>> >>>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> With Regards, >>>>> Noorain Ansari >>>>> http:// >>>>> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> >>>>> http:// >>>>> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com><http://accesssqclinic.blogspot.in/> >>>>> >>>>> >>>>> -- >>>>> Join official facebook page of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES (1120+ members already BANNED for violation) >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> >>>>> 2) Don't post a question in the thread of another member. >>>>> >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> >>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> 6) Jobs posting is not allowed. >>>>> >>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >>>>> allowed. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>> To unsubscribe from this group, send email to >>>>> excel-macros+unsubscr...@googlegroups.com. >>>>> >>>>> >>>>> >>>> >>>> >>>> >>>> -- >>>> Regards, >>>> >>>> Rakesh Kumar Sharma >>>> Contact: +91-9971024741 >>>> >>>> >>>> >>> >>> >>> -- >>> Regards, >>> >>> Rakesh Kumar Sharma >>> Contact: +91-9971024741 >>> >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> To unsubscribe from this group, send email to >>> excel-macros+unsubscr...@googlegroups.com. >>> >>> >>> >> >> >> >> -- >> With Regards, >> Noorain Ansari >> http:// >> <http://www.noorainansari.com>noorainansari.com<http://www.noorainansari.com> >> http:// >> <http://www.excelvbaclinic.blogspot.com>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com><http://accesssqclinic.blogspot.in/> >> >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > > > -- > Regards, > > Rakesh Kumar Sharma > Contact: +91-9971024741 > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Index+Ifferror.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
