Pull out right most data but ignore blanks

Hi guys

I have a straight row of repeating data. I want to pull out the data from the right most coloum titled lets say "How many apples" Currently i am using the formula below and it works but it does not ignore blanks. If the rightmost coloum of how many apples is a blank, excel pull out a zero for me now. I want excel to ignore the blank and search one step back to pull down data from the previous coloum of same title which is not blank. Appreciate your kind help.

How many apples

How many apples

2

blank

So the answer for the above should be 2 and not zero

Formula i am using that does not ignore blanks now.

=LOOKUP(2,1/($1:$1=$F$1),2:2)

What is your data? Text or Number?

Assuming we are looking at row 2.

=INDEX(2:2,1,MATCH(9^99,2:2))