Problem with CELL("contents") in Calc

I want to retrieve the last entered or updated text from some rows a column (not necessarily the last row), as I’m following this video; https://www.youtube.com/watch?v=0QrQT9D25Xk that’s actually an excel video. In this video they are using a formula like this;

=CELL(“contents”)

I try to use that in LibreOffice Calc, but I keep getting an errormessage (504)
Is there any other way I can do the same thing?
I don’t want to use VBA or macros.

Would you, please, describe exactly what =CELL(“contents”) returns in EXCEL?
Please avoid to refer to yotube videos if avoidable at all. Few people here can afford the time to watch that boring stuff. Give information instead.

In this case it returns the last input, or change, to any cell in the document! If you look at the first minutes or so of the video you’ll understand. I need something like this to pass the value in a cell to make some searchable dropdownmenues

Well, I might have better understood your question if it was worded as in your comment above or like “I want an implicit reference to the last cell that was edited”. The answer then had been "There isn’t such a built-in functionality in LibreOffice Calc.
Did someone tell you what the function with that flag will return if many cells changed their content in one go (by insertion into a range e.g.)?

If I use =CELL(“contents”) in Excel, let’s say in cell A1, and then type text in some other random cell, I’ll see that in cell A1. I’m looking for something similar in CALC

===Edit1===
There is no function (with any flag / argument) in Calc returning the current value of the most recently edited cell.
=== End Edit1===

In LibO the CELL() function also is available (for compatibility assumably), and can be used with the flag “contents”. It then returns - no, not the content which might be a formula, but - either the constant content (constant string, constant number) or the formula result without any formatting. To understand the relevance of “witout any formatting” you need to realise that there are some cases where a direct reference not only gets the value but also a format setting of the ‘Numbers’ format type. This is in force if the referenced cell has a date format, the logical (Bolean) format or a currency format. (That’s bad , but fact again.)
Otherwise =CELL(“contents”;A2) will return the same result as =A2 would do.

If I use =CELL(“contents”) in Excel, let’s say in cell A1, and then type text in some other random cell, I’ll see that in cell A1. I’m looking for something similar in CALC