I have about 30 seperate unique codes for various different revenue accounts. The codes are 4 cells to the left of each total revenue number (which is the number i want to pull). I also have a report that has the the revenue account name and what should be the total revenue number in the cell next to it. Let's say the code for "Revenue Account A" on the Report worksheet is T29D and the code for "Revenue Account B" is G56W. If the codes were in column J and the revenue amounts were in column F, I would want the formula where the total revenue number should appear to say If(J14="T29D",F14,If(J14="G56W",F14,If(...... And so on down the line for those 30 codes. What is the best way to do this. It does not necessarily have to be and if statement, I just thought this would be the only way to achieve the desired results. Any input is appreciated.