Re: [libreoffice-users] Calc a formula conundrum

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