Hello helpful people

I have a sheet which performs a bunch of calculations on a list of input numbers.

The results of the calculations are rendered to a column (Say A1:A2500)
The formulae for these calculations are in the cells A1:A2500 (different formula for each cell)

I need to automatically keep the results column sorted in ascending numerical order, to perform a VLOOKUP on them.

I have all the rest of it working fine but I can't find how to perform this (probably!) simple task anywhere.
A manual sort of the column results in no change to the order at all, I am guessing because of the formulae in the cells overriding the sort function??

As for doing it automatically - I'm lost - because my area of expertise is in what I want the spreadsheet for and not in writing Excel spreadsheets

I will be very grateful for any pointers any of you can give me.

Thanks loads in advance.