The formula does work, however it is long and is laborious to add new key words and I’m hoping someone might know a better way of doing it. New key words would be ‘HOLLAND & BARRETT’ and ‘PAYPAL’ and more as needed. I’m wondering if its possible to have a list of key words ?
This may help with your key-word-list. MATCHReturns the relative position of an item in an array that matches a specified value. The function returns the position of the value found in the lookup_array as a number.
Syntax
|MATCH(SearchCriterion; LookupArray; Type)|
|Find more information at:
https://help.libreoffice.org/Calc/Spreadsheet_Functions#VLOOKUP
|
I’ve attached an example – which will make my explanation more clear ? I hope ----- IGraham W764 LibreOffice 4.4.2.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-a-formula-conundrum-tp4199203.html Sent from the Users mailing list archive at Nabble.com.
-- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted