Hi
I have a worksheet with several columns of names (in columns C to U). Some names occur only once, while others occur in more than one column. Within each column, however, each name occurs only once, and they are in alphabetical order.
Meanwhile, column W has a complete list of all the names, once each, in order. Column X has some other data, and then column Y has some numbers I need to retrieve.
What I want to find is, for each of my columns C to U, what is the max of all the numbers corresponding to the names in that column.
I tried with {=MAX(VLOOKUP(C94:C107,$W$94:$Y$224,3))} but it just looks up C94 in $W$94:$Y$224 and returns that value, rather than the max of all the numbers corresponding to names in the C column.
What am I doing wrong, please?
Thanks
PS Ideally, I'd like it to be able to ignore blank cells in the columns of names, because my lists of names in the columns are all different lengths.
I have a worksheet with several columns of names (in columns C to U). Some names occur only once, while others occur in more than one column. Within each column, however, each name occurs only once, and they are in alphabetical order.
Meanwhile, column W has a complete list of all the names, once each, in order. Column X has some other data, and then column Y has some numbers I need to retrieve.
What I want to find is, for each of my columns C to U, what is the max of all the numbers corresponding to the names in that column.
I tried with {=MAX(VLOOKUP(C94:C107,$W$94:$Y$224,3))} but it just looks up C94 in $W$94:$Y$224 and returns that value, rather than the max of all the numbers corresponding to names in the C column.
What am I doing wrong, please?
Thanks
PS Ideally, I'd like it to be able to ignore blank cells in the columns of names, because my lists of names in the columns are all different lengths.