In Excel, I am accustomed to using INDEX(MATCH()) by referencing entire columns, e.g. INDEX(A:A,MATCH(C1,B:B,0)) where C1 is the interesting value, B:B is the column to match C1 value in, and A:A is the column whose matching row index to return. It seems I can MATCH against an entire column but cannot INDEX an entire column.
Looks like many people have run into this:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=9527
Can this feature be developed? I really enjoy LibreOffice Calc, otherwise.