How Do I Combine Rankings for Multiple Categories?

I am doing some screening and analysis on a stock database and I want to rank
each company according to certain criteria. There are approximately 5,000
companies in the database.

So for example, suppose I rank the companies first by their respective
Return on Equity. Let's say in that ranking Microsoft is number 50 of 5,000.
Next I would rank the companies by sales growth. Let's say in that ranking
Microsoft is 175 of 5,000.

What formula, commands or spreadsheet design would I use to have Excel match
all of the companies in the database with their respective scores and add the
two rankings together? For example, to find Microsoft in the two lists and
add the two rankings together for a total score of 225?

Thanks in advance for your help.

I would use two named ranges and the formula VLOOKUP.
For example, if the list for Return on Equity" is on range named "Return",
and the sales growth in a range named "Growth", if you have "Microsoft" (or
the code that you use for Microsoft on the database) on cell A1 the formula
can be:
=VLOOKUP(A1,Returns,2,FALSE)+VLOOKUP(A1,Growth,2,FALSE)

Hope this helps,
Miguel.

"Howard" wrote:

> I am doing some screening and analysis on a stock database and I want to rank
> each company according to certain criteria. There are approximately 5,000
> companies in the database.
>
> So for example, suppose I rank the companies first by their respective
> Return on Equity. Let's say in that ranking Microsoft is number 50 of 5,000.
> Next I would rank the companies by sales growth. Let's say in that ranking
> Microsoft is 175 of 5,000.
>
> What formula, commands or spreadsheet design would I use to have Excel match
> all of the companies in the database with their respective scores and add the
> two rankings together? For example, to find Microsoft in the two lists and
> add the two rankings together for a total score of 225?
>
> Thanks in advance for your help.
>
>
>
>
>