Help with Formula

[Minerva7]

I'm typing this formula into each cell in column named 'Count' in order to look up today's count for each fruit, but it's not quite what I need. I'd like Excel to automatically grab the data in the last populated column (which gets updated daily), then paste column 'K'.

Here's what I have, but it's not quite what I need: =VLookup(A2,A2:J4,9,0)

Source:

[TABLE="width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[/TR]
[TR]
[TD]Product[/TD]
[TD]3/28/19[/TD]
[TD]3/29/19[/TD]
[TD]3/30/19[/TD]
[TD]3/31/19[/TD]
[TD]4/1/19[/TD]
[TD]4/2/19[/TD]
[TD]4/3/19[/TD]
[TD]4/4/19[/TD]
[TD]4/5/19[/TD]
[TD]Count[/TD]
[/TR]
[TR]
[TD]Apples
[/TD]
[TD]5[/TD]
[TD]7[/TD]
[TD]9[/TD]
[TD]3[/TD]
[TD]10[/TD]
[TD]21[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pears[/TD]
[TD]13[/TD]
[TD]3[/TD]
[TD]7[/TD]
[TD]8[/TD]
[TD]5[/TD]
[TD]4[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Oranges[/TD]
[TD]22[/TD]
[TD]25[/TD]
[TD]29[/TD]
[TD]19[/TD]
[TD]15[/TD]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]


Destination:

Same as above, in the last column labeled 'Count'. I'm trying to get Excel to automatically populate today's numbers in the 'Count' column, or lookup the data in the last populated column with a date.

I hope this makes sense. :/ Thanks in advance for any help you can offer.

 

[Michael M]

This from Ron DeBruin I Think.....
In K2

=LOOKUP(2,1/(A2:J2<>""),A2:J2)

Drag down as required

 

[jim may]

I don't understand what you want.

 

[Michael M]

@jim may
I understand the question, but don't understand why you would want that info.
I would have thought a SUM of the used row would be wanted....which is just a simpl SUM anyway !!