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% #N/A
C4 contains =VLOOKUP(B4,B1:C3,2,0) which works.
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: [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
