=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: James <bjloc...@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+unsubscr...@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:mi...@guam.net  mailto:msetze...@gmail.com mailto:msetze...@gmx.com Guam - Where America's Day Begins  G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +------------------------------------------------------------+ -- To unsubscribe e-mail to: users+unsubscr...@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