After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 672319 - wildcarters in vlookup
wildcarters in vlookup
Status: RESOLVED FIXED
Product: Gnumeric
Classification: Applications
Component: Analytics
1.10.x
Other Linux
: Normal normal
: ---
Assigned To: Morten Welinder
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2012-03-18 00:02 UTC by palitos chinos
Modified: 2012-03-18 19:19 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
wildcarters in vlookup (2.29 KB, application/x-gnumeric)
2012-03-18 00:02 UTC, palitos chinos 		Details

Description palitos chinos 2012-03-18 00:02:00 UTC 
Created attachment 210023 [details]
wildcarters in vlookup

i can use wild-carters in dome functions like countif but not in vlookup. I don't know if any other function does not take wild-carters.

This works fine:
=countif(Sheet1!C2:D11,"*"&F2&"*")

But this doesn't
=vlookup("*"&F2&"*",$C$1:$E$10,3,FALSE,FALSE)

I leave an attachment to clarify.
Comment 1 Morten Welinder 2012-03-18 19:13:16 UTC 
Mostly fixed.  The code for this already existed for MATCH and just
had to be hooked up for VLLOKUP/HLOOKUP.  That's done.

I say "mostly fixed" because, evidently, it doesn't work with blanks
in the data.  Bummer!
Comment 2 Morten Welinder 2012-03-18 19:19:20 UTC 
This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.