If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
Anyone see the problem with this, it isn't working. I am tring to put all
the results (in columns AF:AR) into a cell, based on the input Z3 (The input will match only one row in AD2:AD361) Sorry I know I have asked this question tons of different ways but I'm not able to make it work |
#2
|
|||
|
|||
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
Index will not pull all of the data related to one row in a table, it will
only pull one value. For Index to work you need one value to be selected from the left column and one value from the top row. Have you considered filtering you data to get what you want? Tom |
#3
|
|||
|
|||
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
How would I filter the data? That brings up a good point, from the answers
that I am tring to find. In the next column I would like Excel to pick one of the answers based on the a round robyn list and who was picked last. Am I going about this the wrong way. Should I combine the two and only get one answer? Thanks "tompl" wrote: Index will not pull all of the data related to one row in a table, it will only pull one value. For Index to work you need one value to be selected from the left column and one value from the top row. Have you considered filtering you data to get what you want? Tom |
Thread Tools | |
Display Modes | |
|
|