Searchable Dropdown List for Multiple Rows LibreCalc

Is there a way to achieve the searchable dropdown list for multiple rows without using vba or macro in libre calc. I was able to create a single cell searchable dropdown list using some excel references but wasn’t able to create it for multiple rows.

In the referenced tutorial the use of formula CELL(“contents”) or INDIRECT(CELL(“address”)) made it possible for multi row searchable dropdown list. It seems those 2 formula is used to bring in the value of from active cells form whole workbook. They also used a Defined Range using Formula which I wasn’t able to.

Demo for Single Cell.xlsx