Forum Discussion
mark_1971
Jan 09, 2025Copper Contributor
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?