HuskyGrad2010

no problem soddy...thanks though. let me know if you want me to send over my spreadsheet. I noticed that with arrays, AVERAGE yields the correct values but MEDIAN does not.

bdavi77962

Numi, don't bother using this. I tried it on one of my own spreadsheets and it throws out incorrect values.

I'll try to come up with something else.

comp_sci_kid

Thanks soddy, that's what I'm trying to do -- then how would calculate the median of all of those data points?

I think maybe there is something wrong with my excel file since it seems to work for some columns but not all. Or perhaps something that prevents the formula for working. That is to say,I have Company A, B, C, D, E, etc all on the same spreadsheet, but your VLOOKUP only grabs the Revenue data for Company A.

grharmeyer

yes it works for some columns but not for all...

Rasec

Have you tried it as an array function (ctrl, shift, enter)?