Will having a formula behind the text that shows in the cell prevent
alphabetical sorting?

I have a list of text values in column A that are the result of
vlookup functions. When I try to sort, they either don't change, or
sort but incorrectly. Is this due to the formulas?

Is there any way to sort based on the returned value?