Izhar: My "hijacking" comment was directed at Abhishek Bhallawho seems to have asked his own question about combining cellswithin YOUR question about vlookup. (which serves to demonstrate the "confusion" that I mentioned!) Paul----------------------------------------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ----------------------------------------- From: GENIUS <izharra...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Cc: schreiner_p...@att.net Sent: Friday, October 9, 2015 1:12 PM Subject: Re: $$Excel-Macros$$ VLOOKUP NOT WORKING
On Wednesday, 7 October 2015 16:03:31 UTC+5, Paul Schreiner wrote: Is this related to "VLOOKUP NOT WORKING"? I suspect you've "hijacked" Izhar's thread. see forum rules #2:> 2) Don't post a question in the thread of another member. I'll be glad to help, but don't wish to confuse another discussion. Paul------------------------------ ----------- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley ------------------------------ ----------- From: abhishek bhalla <bhalla_...@rediffmail. com> To: excel-...@googlegroups.com Sent: Wednesday, October 7, 2015 5:57 AM Subject: Re: $$Excel-Macros$$ VLOOKUP NOT WORKING Hi all, I want to combine data from different cells into a single. For example: A apple A ant A antique B bat B big I would like to collate data like: A apple, ant, antique B bat, big The letters and words should be in separate columns. Please help I need it urgent. Regards Abhishek Bhalla From: "Izhar"izhar...@gmail.com Sent:Wed, 07 Oct 2015 10:28:25 +0530 To: excel-...@googlegroups.com Subject: $$Excel-Macros$$ VLOOKUP NOT WORKING in the workbook, i have two worksheet i.e. SHEET1 & SHEET2, i want to look the quantity in SHEET2 which does not exist in SHEET1, i applied a formula but does not work, please look at it and correct the formula. > >keep in mind, I';ve applied this formula after filtering those rows which does >not have the quantity > > >Thanks in advance. >-- >Izhar Ul Haq > > >Cell# 009203069072597 > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ > https://www.facebook.com/ discussexcel > > FORUM RULES > > 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) Jobs posting is not allowed. > 6) Sharing copyrighted material and their links is not allowed. > > NOTE : Don';t ever post 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 unsubscribe from this group and stop receiving emails from it, send an > email to excel-macros+unsubscribe@ googlegroups.com. > To post to this group, send email to excel-macros@googlegroups.com. > Visit this group at http://groups.google.com/ group/excel-macros. > For more options, visit https://groups.google.com/d/ optout. > | Get your own FREE website, FREE domain & FREE mobile app with Company email. | Know More > | -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/ discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@ googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/ group/excel-macros. For more options, visit https://groups.google.com/d/ optout. Thank you very much Noorain Ansari and Paul Schreiner, Mr Paul I would like to inform you that my name is izhar and i did not hijack any thread, once again thank you very much for your help -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post 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 unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.