Sorting is throwing my formulas out of place. Looking for solution.

Is your data suitable to use a vlookup rather than a direct link to the cell?

I'd only want to use vlookups as a last resort. Reason being that I am putting this together for another person and I'm not sure that they are familiar with vlookups.

If that's the only way, though, I'm open to hearing about it.

It is a function that means vertical lookup. We use it to search for a value in the first column of a table array and returns a value in the same row from another column in the table array.
But for the formula to work error proof, first value of the source table need to be unique.
If you have a sample worksheet, please share with which I can have a check whether there are any better approaches.

Okay, I've added a sample file to the original post.

Hi,
I have attached solution sheet, Please check the 25 Feb data. Formula is as follows. If the Weekly Reoccuring Template sheet gets modified in terms of the number of Clients, then please modify the $B$3:$K$32 part (there are two parts) accordingly.

Please Login or Register  to view this content.

Solved_TestFile.xlsx

Please if someone could help me figure out why the error occurred just in those cells and how to fix it, I'd be very appreciative. I'm so close yet so far away from having this work.

Can anyone help please?

Usually in a formula, if you put a cell reference without a dollar prefix, it would keep on changing whenever you drag or copy it to other cells. For eg:-

giving $B$4, always points to B4 whether you drag it or not
giving $B4, would change the cell reference index upon dragging. Like $B5, $B6 etc.
giving B4, that this value can change when dragged depending on the direction that you are dragging. B4, C4 etc.

If giving a range (say B4:B100, where there are not dollars prefixed), dragging the formula would change the entire range. B4:B100 becomes B5:B101 etc.

Does this help you? If still in trouble,

The thing is that your solution file worked for the most part, the only problem was that it wasn't pulling the correct information into cells BS9, BT9, and BU9. They were all blank in the original version, but in your copy, those cells were filled in with 8, 8, and 10 accordingly. If I can just find a solution to this problem, it will work perfectly.

Doesn't anyone know how to fix this? It's so close to working, I'd hate to think that I can't use it just because of a small error.

Well I guess I'll give this one last try before giving up. If anyone can help resolve the error in the file from aksappy, please let me know.

Thank you!

Well, thanks anyways guys. I guess we can consider this request abandoned.