In a spreadsheet from cell D4 to D23 i have customer numbers, they are ranked
1 to 20 for sales in 2005. the rankings 1 to 20 are in column C range c4 to
c23 In cell I4 toI23 same thing except it is 2004 sales. They are ranked 1
to 20 which are in column H range H4 to h23

What I am trying to to is compare the customer number in column D and look
in Column I, when it finds a match then I want to look in the rankings column
H and put that value in Column B next to the same customer number.

The end result is I would be able to see where they were in 2004 against 2005