I have a fairly significant amount of data that I would like to have at least
two different methods of sorting similar to, or including a VLookup function.


For example, if comparing a widget company to the widget industry as a
whole, I would like to compare the subject company to companies with the same
gross annual sales, and of those companies to which the subject is compared,
I want the option of swithing the comparison so that the subject company is
compared to the upper quartile, or the mid-range, or the lower quartile in
net profits.

I have a Vlookup set up for the quartiles, but I also need these cells to
sort the data based on the size or type of company I am analyzing as well.
The source table has the quartile data set up horizontally and the other
variables vertically (at the moment).