Forum Discussion

mark_1971's avatar
mark_1971
Copper Contributor
Jan 09, 2025

Calculating order of cell results based on a VLOOKUP table

Hi - I've been really battling to find a solution to this problem.

I have a table with cells populated from a VLOOKUP function which are then weighted to provide an raw weighted number which will be used for ranking/prioritisation purposes. I need to show in a column the order in which certain actions should take place, but all the cells/values must be sorted to correspond with the calculated overall raw weighted number.

 

I've attached an image which hopefully explains what I'm looking for. Can anybody help?

 

BTW I'm working off a Mac.

 

Many thanks,

Mark

 

  • Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources