Is this what you mean:
=INDIRECT("$A"&MATCH(MIN(B:B);B:B;0))
> Op 24 jan. 2021, om 23:14 heeft James <[email protected]> het volgende
> geschreven:
>
> I want to find the row in column A that corresponds to the row of a value in
> column B.
>
> eg.
>
> row A B
>
> 1 10 220000
>
> 2 20 150000
>
> 3 30 3000
>
> 4 40 10
>
> =some_function('A',minimum_function(B));
>
> where minimum_function(B) returns 4 and some_function('A',4) returns the
> value in column A at row 4.
>
>
>
> --
> To unsubscribe e-mail to: [email protected]
> Problems?
> https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
> List archive: https://listarchives.libreoffice.org/global/users/
> Privacy Policy: https://www.documentfoundation.org/privacy
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
