Re: gnumeric-list Digest, Vol 95, Issue 12



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 <chepalitos gmail com> 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, <gnumeric-list-request gnome org> wrote:
Send gnumeric-list mailing list submissions to
       gnumeric-list gnome org

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
       gnumeric-list-request gnome org

You can reach the person managing the list at
       gnumeric-list-owner gnome org

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 <mortenw gnome org>
To: Federico Schneeberger <federico tangofandango com ar>
Cc: gnumeric-list gnome org
Subject: Re: wildcards in vlookup
Message-ID:
       <CANv4PNkLn3-XQkkHNV4qV0_BRP+Ec_quKOHXySx_oBhPDBaBeQ 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 <melseder yahoo com>
To: glove mts net, gminuk cc umanitoba ca,
       gnome-admin-tools-admin ximian com,     gnumeric-list gnome org,
       grant page freedom55financial com
Message-ID:
       <1331758874 71376 YahooMailNeo web121905 mail ne1 yahoo com>
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
gnumeric-list gnome org
http://mail.gnome.org/mailman/listinfo/gnumeric-list


End of gnumeric-list Digest, Vol 95, Issue 12
*********************************************


Attachment: Book1.gnumeric
Description: application/gnumeric



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]