Re: [libreoffice-users] LOOKUP Function: Bug or Finger Trouble

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