If I understand you correctly =VLOOKUP(A4;$A$1:$B$3;2;0) in B4 will do what you want
> Op 6 jun. 2024, om 05:33 heeft James <[email protected]> het volgende > geschreven: > > Say I have column A with the numbers 1, 2, 3: > A1 (1) > A2 (2) > A3 (3) > and column B with the numbers 11, 22, 33: > B1 (11) > B2 (22) > B3 (33) > > Column A Row 4 contains a reference to one of row 1, 2, or 3 (I switch which > row is referenced so I can see the effects of different choices). > > Is there a calc function which can find which row I chose so I automatically > populate row 4, column B? > Row 4, column A matches one of the rows 1-3... > > -- > 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
