Re: [libreoffice-users] vlookup help

=On 22 Jun 2024 at 16:12, James wrote:


Date sent:60;Sat, 22 Jun 2024 16:12:13 -0400</span>
To:0;LibreOffice-list 
<users@global.libreoffice.org>
From:&#160;James &lt;bjlockie@lockie.ca>
Subject:;[libreoffice-users] vlookup help


> I am having trouble with vlookup.
> I put a test file at:
> https://www.mediafire.com/file/puq9nuu982beicl/vlookup-test.ods/file
>
> The spreadsheet is:
> One $1 1%> Two $2 2%> Three $3 3%> current $2 2%60; #N/A


In D4 I put
=INDEX(A1:A3,MATCH(C4,$C$1:$C$3),1)
and that displays Two


If I understand what you are looking for. Match returns the row.


> C4 contains =VLOOKUP(B4,B1:C3,2,0) which works.</div>> D4 contains =VLOOKUP(C4,A1:C3,1,0) which 
> displays #N/A but I want it to
> display whatever is in column A of the matching row.
> "Two" in this case.
> Whatenever I change B4, D4 should display the matching row of column A/
>
> --
> 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




+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)60;
mailto:mikes@guam.net&#160;
mailto:msetzerii@gmail.com
mailto:msetzerii@gmx.com
Guam - Where America's Day Begins&#160;
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+




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