Sort Worksheet to Match First Column

Hello again. Attached a workbook for this one. I have data in Column A (green). The data in column C matches Column A. I need to re-sort the worksheet, from columns B:Z to line up with the Data in column A. Either by formula or VBA. I've been trying to use MATCH formulas but I'm not making much headway with them. Any thoughts? Please and Thank you.

***Note. There will be blanks/gaps. This is part of what I'm trying to find out. What I have descriptions for/what I need descriptions for. Column A has 927 rows. Columns B:Z have 489 rows***

This looks great. And the results are exactly what I'm looking for...just having a hard time figuring out how you did it. I keep over-riding data if I try to apply the formula. So then I tried working in reverse. A sheet full of formulas....and I manage to over-ride those. I feel like the answer really simple and I'm missing it.

Oh and thank you VERY much. Greatly Appreciated.

You are very welcome.

So here's how it works. Sheet2 has column A which just refers to column A of Sheet1, for easy reference of that data. (It could have been omitted.)

Then ever other column has a formula like this:

Formula:

Please Login or Register  to view this content.

The MATCH portion takes the value from column A and then finds the matching value in column C of Sheet1. Then it takes that row and retrieves the corresponding value for the appropriate column.

I see where I was going wrong...kept trying to do everything on one sheet. Works great now. Thanks again for the help.

Quickest way to do it was using formulas on a second sheet. Certainly not the only possibility.