Hi,

I have a whole list of information i.e. First Name (column A), Last Name (column B), anniversary (column C). Then on another sheet I have a list of all the months of the year in row 1.

I am trying to create a lookup that will place the persons surname under the corresponding month.

Thanks in advance.

Alex