Compute composite score of stock symbols

[momo333]

Hi,

I am a total newbie to excel.

I have two sheets, each with an imported csv of ranked stock symbols.

Each stock symbol on each sheet has a different score.

For example IBM has a score on 1 sheet of "82"

on the second sheet it may have a score of "400"

I want to rescore it as 482 (& repeat for every stock symbol)

Then re-sort the new composite scored stock symbol ASC.

Hope that makes sense.

Thanks for taking a look.

 

[Robert Mika]

Try with INDEX/MATCH to bring values from one sheet to another and then just add those two numbers.

If you provide some data we can probably give more information on "how to".

 

[momo333]

Thank you for the quick reply.

I will try to work with your suggestion for awhile and post back with some data if it gets over my head.

Thanks again,

Jeff