Excel sorting problem

[newbie0101010]

Hello,

i am working on a project in my company where i automate the system for calculating needed recoruses for the operation. The formula and the calculations are working nicely and smooth, but the operator has to have the last number ''LOKACIJA'' far right in table on sheet ''RAZLIKA'' sorted from lowest to highest positon. Lowest meaning V1004 and highest is cca v70000. The problem i have is when i try to sort from low to max is that i get this problem: lowest: V100, V2000, V300, V500, V600, V70000. It doesnt work like it should -> V100, V200, V300, V400, ..... V6000,. V70000. The cells for ''LOKACIJA'' are iferror vlookups across sheets dn01 to dn06.
I urgently need help since i need to finish my project.

Thank you for helping,
LINK: Google Sheets: Sign-in Google Sheets: Sign-in

newbie.

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Problem with sorting location number
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.