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
Scenario.xls
Description: MS-Excel spreadsheet
