Hi,

I have two worksheets, the first lists managers and lists dates they
transfered to branches.

The layout is :-

Manager Branch Start Date

So the managers appear in column A several times. The second worksheet gives
branch sales history by year, layout is :-

Branch Name 2005 2006 2007 2008

I'm trying to create worksheet which gives sales history by manager.

I'm not sure if VLOOKUP is the way to go, but I'm attempting to use it, but
it only finds the first occurance of the managers name in column A.

Can someone suggest a solution?

--
Rich
http://www.richdavies.com/fantasy-football.htm
Free English Premier League Fantasy Football

** Posted from http://www.teranews.com **