Please find the attached sheet i could able to build formula for single line item
But i want if the criteria is having mulitple line items the results should display as Date description, Date description, Date description. Please help me in this concern, Thanks, Raj On Sat, Jan 8, 2011 at 10:49 AM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > > > Hi , > > Please help me in this concern, > > In this sheet i am trying to place vlookup for multiple fields yaar > > it should through the description and date in AG column basing on list of > activities. > but i should get this in horizontal basis.. > > can anyone plz help me in this concern. > > for example > if one activity is performed twice which is shown on top left hand corner. > > IRS Publications activity has two line items then it should come as > against the J102 which is IRS Publications it should through up the > description and date in this manner > > pdf28 Monday, January 03, 2011,pdf24 Monday, January 03, 2011 > > -- > -Thanks, > Raj > -- ---------------------------------------------------------------------------------- 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/pages/discussexcelcom/160307843985936?v=wall&ref=ts
query with formula.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet