Counta inside Vlookup

[Sigrah117]

I am trying to remember how to do something i had done before.
Two separate tabs, lets call them A and B.
On Tab A is my summary of everything happening on Tab B. Tab B has columns made up of dates and amounts
What I am trying to do is have a certain cell on Tab A that does not move show the last entry in a column from Tab B. This way as I enter data on a new row in the column on Tab B it will automatically change the cell on Tab A to show the most recent entry.

This has been driving me crazy and any help would be greatly appreciated.

 

[Aryatect]

Hi, Welcome to the board, are you looking for something like below:

Book1
	A	B
1	7/6/2019	137
2	7/7/2019	160
3	7/6/2019	171
4	7/7/2019	158
5	7/6/2019	172
6	7/7/2019	167
7	7/6/2019	173
8	7/7/2019	189
9	7/6/2019	187
10	7/7/2019	112
11	7/6/2019	171
12	7/7/2019	159
13	7/6/2019	165
14	7/7/2019	105
15	7/6/2019	138
16	7/7/2019	160
17	7/6/2019	166
Sheet2

Book1
	A	B
2	Date	Time
3	7/6/2019	166
Sheet1

Cell Formulas
Range	Formula
A3	{=INDEX(Sheet2!A:A,LARGE((Sheet2!A:A<>"")*ROW(Sheet2!A:A),1))}
B3	{=INDEX(Sheet2!B:B,LARGE((Sheet2!A:A<>"")*ROW(Sheet2!A:A),1))}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Sigrah117]

OMG it was INDEX not VLOOKUP. I feel like a tard, thanks for jogging my memory, i got it working.