Sheet 1, row 1 has labels: name, Jan, Feb, mar
A2:A20 has some names
B2:M20 has numbers

Sheet 2 in A2 I enter a name, in B2 I enter a date,
in C2 I enter =VLOOKUP(A2,Sheet1!A1:M20,MONTH(Sheet2!B2)+1,FALSE )

So if B2 is Fred and the date in some time in March, the formula find Fred;
row on Sheet1 and takes from the 4th column Fred's March data

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"microsoft.public" wrote in message
...
I have a worksheet that has names in column 1, and columns 2 - 13 are the
months. I want to create a formula to move the values in columns 2 - 13 to
another sheet based on the month.

Thanks