SEARCH and FIND and V.LOOKUP combined

Ø

Øyvind Granberg

Hi...

I wonder...
I am using the v.lookup function in a cell.
But the text in the matrix and the cell with the lookup value not always are
exactly the same.
Ex; "Hull" and "Hull City" or "dumb" in "Old dumb fart"
I have found that I can use SEARCH or SEARCHB to find a word in a text
string.

How do I use SEARCH in combination that with the v.lookup function in a
formula?



--

Vennlig hilsen
Øyvind Granberg

(e-mail address removed)
www.tresfjording.com
 
T

T. Valko

Use wildcards:

=VLOOKUP("*Hull*",F1:G5,2,0)

Will match Hull City

If the lookup_value is in a cell:

A1 = Hull

=VLOOKUP("*"&A1&"*",F1:G5,2,0)
 
S

SmartbizAustralia

Be careful with vlookup as if it cannot find a match it returns a
value from another cell...and that means your figures can be out.

Index/match is better...get the vlookup working and then it's just a
minor change in the parameters..

Regards,
Tom Bizannes
Microsoft Excel Specialist
Sydney, Australia
http://www.macroview.com.au
 
D

Dave Peterson

Not using the formula that Biff suggested.

=vlookup() with the fourth parm of false or 0 will look for exact matches.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top