Does anyone know how to sort the results from a formula into ascending order?

[Chris Waller]

Morning Friends I am after some help with what I think is a complex formula.

I have two spreadsheets. One the first is a summary of the information contained on the second sheet and I am trying to create a formula that will lift reference data from the second sheet and put it into ascending order.

On Sheet1 I have a dropdown list at cell O2 this contains the project number.
The project title is in cell G2.
In cells A5 to A11 I need a formula to pick up the invoice number which relates to the project number and title. This information is contained in cell F3 onwards on Sheet2

On Sheet2 cell D3 onwards contains the project number
Cell C3 onwards contains the title of the project title
Cell F3 onwards contains the invoice number that needs to populate cells A5 to A11 on Sheet1. When this information is in cells A5 to A11 I need it to display in ascending number order.

I do have a fair knowledge of Excel, but this just alludes me at the moment. I would really appreciate some help with this. TIA

 

[DILIPandey]

Hi Chris, sort should work on the formula results.

Is it alphanumeric text which sort is not recognizing or not sorting as per your expectations ?


Regards,
DILIPandey