Forum Discussion
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 ...
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#.