Re: [libreoffice-users] calc

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 <bjlockie@lockie.ca> 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: users+unsubscribe@global.libreoffice.org
> > 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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