I appreciate the input so far, though it isn't really getting me where I'm trying to be. I may not be explaining it correctly.

I'm looking to write a formula that will search (for example) cells A2:A14, find the value in the last cell with data, then depending on what cell location that is (lets say it is A12), multiply the value in A12 by the number in the same row (row 12) but another column (column N).

I'm looking for this because each month the last cell with data in any particular column can change and I always want to multiply the value in the last data cell with a number in the same row, just a different column.

It's a little tough I'm thinking. Thanks!