Results 1 to 4 of 4

Thread: Need help pulling data from one sheet to another using index/match formulas

  1. #1

    Cool Need help pulling data from one sheet to another using index/match formulas



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi all excel enthusiasts,

    I need help fixing my formulas to capture data from one sheet to another using index/match formulas. I have three different criterias such as months, salesperson & location and i need to pull information based on those criterias from the two side sheets. any help would be greatly appreciated. I have started on the formulas but i found that not every salespersons data seems to pull through.

    P.S it wouldnt let me attach a macro file so here is an external link to my working file mediafire(.com)/?08u96m5ja8ra3zh

    (remove the brackets)

    Thanks,

  2. #2
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    674
    Articles
    0
    Access doesn't seem to be available to guests on that site.
    If you click "Go Advanced" and scroll down to Manage Attachments you will be able to upload your workbook here by following the instructions.

  3. #3
    Hopefully this works!
    Attached Thumbnails Attached Thumbnails Click image for larger version. 

Name:	Capture.PNG 
Views:	5 
Size:	39.2 KB 
ID:	6607  
    Attached Files Attached Files

  4. #4
    Magician Hercules1946's Avatar
    Join Date
    Mar 2013
    Location
    York, England
    Posts
    674
    Articles
    0
    Quote Originally Posted by gungill2017 View Post
    Hopefully this works!

    Yes it worked, but Im afraid it doesnt help Im afraid. Its like asking for directions to a local shop, and being given a map of the world !

    Seriously, if someone is going to assist you in a forum they need some data that shows what you are trying to do, and illustrates the problem you need help with.
    Theres no reason why this can't be a complex spreadsheet, provided that its easy to focus on what you need help with, which it definitely isn't with what you have provided.
    I don't know if you or someone else can provide something that addresses your problem more directly and simply, but if not you might need the help of a professional.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •