=VLOOKUP(A4;$A$1:$B$3;2;0) The last argument (0) makes VLOOKUP find an exact match to whatever is in A4. This means that if A4 is empty, or contains a value that does not exist in the range it will respond with N/A
Op 7 jun. 2024, om 19:11 heeft Ekerette Ekpo <ekerettee@gmail.com> het volgende geschreven: How did you do it with vlookup? I tried it out and ended up with a #N/A in cell B4. On Thu, 6 Jun 2024, 22:33 James, <bjlockie@lockie.ca> wrote:Thanks, got vlookup to do what I want. :-) -- 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