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