Hello everyone,

What would be an easy way of matching a name and returning the corresponding row of values to another sheet?

Maybe this is relating to a macro but if it can be done with functions that would be great because then I could follow along and perhaps change them later.

As an example of what I want to do:
In sheet two I have the months of the year in column A in a random order. In sheet one I have the months of the year in random order in column A followed by say 5 statistics that correspond to to that month in columns B,C,D,E and F. I would like excel to find the matching month in one and copy those columns (B to F), back into sheet two next to the right month in say row H.

Any suggestions?