Forum Discussion

markshep's avatar
markshep
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 a 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

 

excel
Excel on Mac
Formulas and Functions

1 Reply

  • Steve_SumProductCom's avatar
    Steve_SumProductCom
    MVP
    Jan 09, 2025

    If you want the DMA#'s to show in the order of the weighted result in H, you could use =SORTBY(B7:B12,H7,H12).  I'm not sure if this is exactly what you're looking for.  It would help if you show examples of the values you want to see in column I, if it's more than just the DMA#.