Hi,

I have a number of work sites that are ranked from 1 to 1,000 based on a risk score. There are various data associated with each site and I want to pull select data out for each ranked site based on certain criteria.

However, some of the ranked sites are tied. In the rankings column, it may show in chrono order: 1, 2, 3, 4, 5, 5, 5, 8, 9...

In my worksheet where I am retrieving data I am using VLOOKUP which uses the ranking number (I've manually entered down a column) as the lookup_value. However, in the example above, I pull the information from the 5th ranked site, however, I get "#N/A" for the 6th and 7th ranked sites.

Any suggestions on how to do this properly? I've used array based formulas in the past, but I'm a bit rusty with them (read alot!).

Thanks to any that can provide some advice.