Op 5-3-2022 om 20:03 schreef Greg Saunders:
I have attached a spreadsheet
You haven't. I think you cannot add attachments on this list.
Leo
that
demonstrates my issue well. Yes its complex.
Column A is a concatenation of columns B and
C. I use column A as a key for the cells in columns B and C.
Columns E and F represent how I want to use
the list created by columns A..C.
Column E uses data validation pull down list
to select the key from column A. The LOOKUP function in column
F is used to return thesubcategorymatching
theselected key. Only it doesn't
always work as intended.
Have I found a bug or am I being a nob?
Many thanks
--
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
