For a tutorial video on 'index' and 'match' see "LibreOffice Calc -
Index and Match": https://www.youtube.com/watch?v=8zydk03ILXs
On 11/4/2016 2:48 PM, Paul D. Mirowsky wrote:
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.
MATCH
Returns 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: [email protected]
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
