Sorry. Ok. this is the thing I can use wildcards in some functions but not in vlookup for example.
=countif(Sheet1!B1:C8,"*"&E1&"*") works
=vlookup("*"&E1&"*",Sheet1!C1:D8,2,FALSE,FALSE) doesn't
Tell me if it is a bug or its me
Federico
On Thu, Mar 15, 2012 at 10:00 PM, Palitos Chinos <[email protected]>wrote:
> But, isn't a way to use wildcards in functions with cells like reference
> values?
> Like this for example?
>
> A1=countif(Sheet1!B1:C8,*E1*&"*")
>
> Federico
>
>
> On Thu, Mar 15, 2012 at 9:00 AM, <[email protected]> wrote:
>
>> Send gnumeric-list mailing list submissions to
>> [email protected]
>>
>> To subscribe or unsubscribe via the World Wide Web, visit
>> http://mail.gnome.org/mailman/listinfo/gnumeric-list
>> or, via email, send a message with subject or body 'help' to
>> [email protected]
>>
>> You can reach the person managing the list at
>> [email protected]
>>
>> When replying, please edit your Subject line so it is more specific
>> than "Re: Contents of gnumeric-list digest..."
>>
>>
>> Today's Topics:
>>
>> 1. Re: wildcards in vlookup (Morten Welinder)
>> 2. (no subject) (Mel Seder)
>>
>>
>> ----------------------------------------------------------------------
>>
>> Message: 1
>> Date: Wed, 14 Mar 2012 09:00:10 -0400
>> From: Morten Welinder <[email protected]>
>> To: Federico Schneeberger <[email protected]>
>> Cc: [email protected]
>> Subject: Re: wildcards in vlookup
>> Message-ID:
>> <
>> canv4pnkln3-xqkkhnv4qv0_brp+ec_qukohxysx_obhpdba...@mail.gmail.com>
>> Content-Type: text/plain; charset=ISO-8859-1
>>
>> If it doesn't work like XL (and XL isn't obviously bogus) then please file
>> a concrete example at bugzilla.gnome.org
>>
>> Thanks,
>>
>> Morten
>>
>>
>> ------------------------------
>>
>> Message: 2
>> Date: Wed, 14 Mar 2012 14:01:14 -0700 (PDT)
>> From: Mel Seder <[email protected]>
>> To: [email protected], [email protected],
>> [email protected], [email protected],
>> [email protected]
>> Message-ID:
>> <[email protected]>
>> Content-Type: text/plain; charset="us-ascii"
>>
>>
>> http://simposiobrasileiro.estudiocultural.com.br/sbo/fotos/info.php?chapter11.jpeg
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL: <
>> http://mail.gnome.org/archives/gnumeric-list/attachments/20120314/16e83705/attachment.html
>> >
>>
>> ------------------------------
>>
>> _______________________________________________
>> gnumeric-list mailing list
>> [email protected]
>> http://mail.gnome.org/mailman/listinfo/gnumeric-list
>>
>>
>> End of gnumeric-list Digest, Vol 95, Issue 12
>> *********************************************
>>
>
>
Book1.gnumeric
Description: application/gnumeric
_______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
