+ Reply to Thread
Results 1 to 2 of 2

HLOOKUP and INDEX/MATCH?

  1. #1
    Registered User
    Join Date
    10-19-2011
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    4

    HLOOKUP and INDEX/MATCH?

    Hello all. I have yet another issue with some Excel functions. What i need to do it pull the entire list of reps by their ID from the Team Rep List By Month file for any given month selected in cell L1 on Stars By Month By Team file. If you look at the red text in the file, (starting at cell W24:AB37) you can see the format im trying to get.

    The idea behind this is, sometimes reps change teams different months. I know there is a way to do it, I'm just having a brain fart!

    Thanks in advance guys!

    -Steve Stars by Month by Team 2012HELP.xlsTeam Rep List By MonthHELP.xls

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: HLOOKUP and INDEX/MATCH?

    Hi,

    I am already seeing the red text (values) in the cells W24 onwards, so the formulas are working fine there because this region is already having values.
    You have written "you can see the format im trying to get" -> so this confused me, you are looking for values or formats?

    I suggest you to put both of your different worksheets from different workbook into one workbook for better understanding and then indicate clearly in target sheet what you are trying to achieve from source sheet. Hope I am clear here, if not let me know. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1