I have an excel document with the LOOKUP formula which grabs the last entered date from another sheet. From below, you can see the date for 'Person One" is also the last date entry on the second image.
The Excel formula I used was
=LOOKUP(2,1/('Person One'!C:C>0),'Person One'!C:C)
However, when I use the same formula on Google Sheets, it returns an error stating:
Did not find value '2' in LOOKUP evaluation.
or it gives me the topmost value which is 'Last Visit' and I am not sure what I am doing wrong.