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.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet