Re: [libreoffice-users] calc

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 <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