Last Occurance of a value formula

[jcountry22]

trying to come up with a formula that takes avrg Jan Purchase Price Less December price * Qty of JAN.

my obstacle is that if there is no Dec price, to have the formula pick up Nov price. If no NOV price, then the last month and so forth...

then I'll have the same for FEB price LESS dec price.. if no DEC then Nov, if not NOV then, OCT and so forth.

months are sequential along row 3

all avrg purchase prices are in the same row (start on row 4) on SHEET 1 ----- Qty for same item is in the same row (row 4) on SHEET 2, occur in the same columns
jan 2017 = b4
feb 2017 = c4
and so forth for the columns.

 

[JazzSP8]

It's not clear how you data is set up, however it sounds as though you might want to be using the last number in a sequence?

You can use a formula like this to find the last value in a row (or column / range!).

=LOOKUP(2,1/(NOT(ISBLANK(1:1))),1:1)

That will find you the last value in Row 1, you can change this to columns or a range of data if required.

You'd use it like;

=[Jan Purchase Price]-LOOKUP(2,1/(NOT(ISBLANK(1:1))),1:1)*[Qty of JAN]

If you can't work with that then post back with an example of your data and an expected result, remember we can't see your data and aren't familiar with your setup at all

 

[jcountry22]

That works perfectly!!! i just had to do as you mentioned and change the columns/range of data i'm wanting to find the last available value in.