matrix vlookup

  1. P

    Excel: Search for and return values in a data range without an empty cell?

    Not sure how to properly explain this. I have a table of food items only some of which will be ordered. In a separate tab I want to list out only those items that need to be ordered with the order quantity. For example here is a data set: <colgroup><col><col><col><col><col...
  2. J

    VBA Copy & Reference from Sheets & Create Matrix

    Hi All, Just needing some help creating a matrix on one of my sheets, I have 3 sheets with different sets of data on them which will then be used to create a matrix style view, please note that the data in worksheets (Checklist, Server_Listing & Exceptions) will be dynamic and new data will be...
  3. S

    Lookup based on criteria in named range, then concatenate results

    we have an interesting formula to figure out. First, we count the following, where MYDATE needs to fall between the two dates. REGISTER.DT and EXIT.DT are both named ranges A:A and B:B, MYDATE is a named range that points at C1 =SUMPRODUCT(--(REGISTER.DT<=MYDATE)*(EXIT.DT>=MYDATE)) Now for...
  4. L

    Matrix Table Lookups?

    Hi guys, I've been stumped on how to do this! I need excel to be able to populate that Points field automatically depending on what the start and end cycles are. Is there some sort of VLookup formula that you could use? Any help would be much appreciated! Thanks!

Some videos you may like

This Week's Hot Topics