Please refer to the attached Excel doc.
In both tables the names are connected to the numerical values per row. I created these two tables as an example, but the real situation can contain several hundred rows with various names.
I need a formula to find and match the names, while returning the proper ytd total for that particular name. For example, the formula should be entered in cell H6 that would arrange the rows, so that they matched table one. However, the values need to stay with the related names after the rearrangement. I apologize if the question is difficult to understand.
Bookmarks