Be sure to include the *$* symbol in the Array.
Remember: the Index, *2*, represents the (second) column, which is
referenced to the leftmost column within the (locked) Array, *$A$2:$B$4*.
NOTE: The data in column *A *need not be only a numeric value; the data
may be text also.
Op 7 jun. 2024, om 19:11 heeft Ekerette Ekpo<ekeret...@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.
--
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
