Sort cells with formula

[Alpacino]

Hi peeps,

Need some help with this one. I've got 2 columns with vlookup formulas column b gives names column c has values I like to sort this desending order but because they have formula it doesn't work anyoe help please?

Thank you!

 

[kpark91]

Use filters to sort.

 

[Jonmo1]

You can do it, but you have to include the column with the lookup value in the sort...

if the vlookup formulas are in column B and C, and the lookup values are in A

You would select all 3 columns (A:C) when you sort, and sort by column C