Hi all,

I have made a database, which contains information about different companies. It is a rating system that returns a percentage after a number of calculations. The calculations are on Spreadsheet 4 and the eventual outcome is on Spreadsheet 5.

Spreadsheet 4:
Company names are in between cells: a23:a40
Ratings appear between cells: o23:o40

I have linked the rating outcomes in Spreadsheet 5, but it doesn't assign the right company names with the right ratings.

I have set up Spreadsheet 5 in the following manner.
Spreadsheet 5:
Rating: a1:a19
Outcome: b1:b19 (but this has to be in the right order)

Which function do i have to insert in order to get the outcome in the right order?

Thx you for your time,

Peter van den Berg