Ignore me, I think I misunderstodd your "vlookup" command which now looks right to me. Sorry.
--hymie! On Thu, Jun 06, 2024 at 08:10:42AM -0400, hymie! wrote: > I believe what OP wants is "Give me the contents of the cell at Column B, > Row the-number-that-appears-in-cell-A4" > > I think it can be done with CONCAT but I wouldn't bet money on it. > > --hymie! > > On Thu, Jun 06, 2024 at 12:43:17PM +0200, Rob Jasper wrote: > > 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 > > -- 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
