Hi Ashish, Thank you so much for your quick response.
Yes, it did help, but the problem was when I tried to implement this formula in my work sheet, I am getting an error message, could you please advise what could be the reason for this error that would be great. Error Message =lookupall(C2,'Report 1'!$G$2:$K$5760,5) Thanks & Regards, Francis ________________________________ From: ashish koul <koul.ash...@gmail.com> To: excel-macros@googlegroups.com Sent: Friday, 3 August 2012 10:35 PM Subject: Re: $$Excel-Macros$$ Fw: Urgent Help needed check the attachment see if it helps On Fri, Aug 3, 2012 at 7:05 PM, francis vinod <francis_vi...@yahoo.co.in> wrote: Hi Don, > > >I never said my request is more urgent than other's request, since I didn't >get any response to my earlier mail and I had to do some reporting so included >the word 'urgent' in the subject line that's all. > >Thanks & Regards, >Francis > > >________________________________ > From: dguillett1 <dguille...@gmail.com> >To: excel-macros@googlegroups.com >Sent: Friday, 3 August 2012 5:44 PM >Subject: Re: $$Excel-Macros$$ Fw: Urgent Help needed > > > >Why is your request more urgent than the request of any of the others? > >Don Guillett >Microsoft Excel Developer >SalesAid Software >dguille...@gmail.com >From: francis vinod >Sent: Friday, August 03, 2012 2:35 AM >To: excel-macros@googlegroups.com >Subject: $$Excel-Macros$$ Fw: Urgent Help needed > Hello Experts, > >Could you please provide me a solution on the below scenario. > >Thanks & Regards, > >Francis > >----- Forwarded Message ----- >From: francis vinod <francis_vi...@yahoo.co.in> >To: "excel-macros@googlegroups.com" <excel-macros@googlegroups.com> >Sent: Wednesday, 1 August 2012 6:54 PM >Subject: Help needed > > >Hello Team, > > > >Could you please help me in the below scenario. >I have two different reports from which I have to prepare a single report for reporting purpose. >In sheet 1 the reports contains tracking#, HW details etc. & and sheet 2 the report contains the values of the HW, tracking # etc > >The report which I want should have the details of both Shee1 & Sheet 2 for which I have used the Vlookup formula and its fine. The issue what I am facing is a single tracking # can have multiple line items and in the equipment report the equipments are split into seperate rows. For eg, If a tracking # has 5 different equipments with discreptions in 5 lineitems then when I use a VLookup formula it only shows the detail of equipment in 1st line. > > >So I want your help on this so that I get all the 5 equipment details in my report. > > > >Please find attached the excel file with an example. > > >If you could guide me it would be a great help and learning for me. > > >Thanks & Regards, >Francis > >-- >FORUM RULES (986+ 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. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. > >------------------------------------------------------------------------------------------------------ >To post to this group, send email to excel-macros@googlegroups.com > >To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com > > > -- >FORUM RULES (986+ 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. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners and members are not responsible for any loss. > >------------------------------------------------------------------------------------------------------ >To post to this group, send email to excel-macros@googlegroups.com > >To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com > > > > > > -- >FORUM RULES (986+ 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. > >NOTE : Don't ever post personal or confidential data in a workbook. Forum >owners and members are not responsible for any loss. > >------------------------------------------------------------------------------------------------------ >To post to this group, send email to excel-macros@googlegroups.com > >To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com > > > -- Regards Ashish Koul Visit http://www.excelvbamacros.com/ http://www.accessvbamacros.com/ PBefore printing, think about the environment. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank 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.
