=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 <[email protected]> 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, <[email protected]> wrote: > >> Thanks, got vlookup to do what I want. :-) >> >> -- >> 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 >> > > -- > 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 -- 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
