I would like to use Serching function for an excel file that would operate as
a dictionary. So I wrote words and expressions to column "A" and the same in
a foreign language to column "B" (in worksheet #1).
I made an empty cell in an other worksheet (worksheet #2) where I would give
the word that I search. I made the following settings: "Function searching":
Searching value: A2
Table: Worksheet #2!A:B
Number of column: 2

The searching results are mixed and do not give correct value.
What can be the problem?

You probably need to specify an exact match.

=vlookup(A2,#2!A:B,2,False)

--
Regards,
Tom Ogilvy


"sheva" wrote in message
...
I would like to use Serching function for an excel file that would operate
as
a dictionary. So I wrote words and expressions to column "A" and the same
in
a foreign language to column "B" (in worksheet #1).
I made an empty cell in an other worksheet (worksheet #2) where I would
give
the word that I search. I made the following settings: "Function
searching":
Searching value: A2
Table: Worksheet #2!A:B
Number of column: 2

The searching results are mixed and do not give correct value.
What can be the problem?

Yes, it's working correctly in this way, but i would like to search for not
exact match too.
Is it possible?

"Tom Ogilvy" wrote:

You probably need to specify an exact match.

=vlookup(A2,#2!A:B,2,False)

--
Regards,
Tom Ogilvy


"sheva" wrote in message
...
I would like to use Serching function for an excel file that would operate
as
a dictionary. So I wrote words and expressions to column "A" and the same
in
a foreign language to column "B" (in worksheet #1).
I made an empty cell in an other worksheet (worksheet #2) where I would
give
the word that I search. I made the following settings: "Function
searching":
Searching value: A2
Table: Worksheet #2!A:B
Number of column: 2

The searching results are mixed and do not give correct value.
What can be the problem?

Yes, if your willing to get the wrong answer.

I guess it depends on what what you mean by not an exact match.

If you are looking for a word that contains the word dog you can do

=vlookup("*dog*",A1:B100,2,False)

for a word that begins with Dog

=vlookup("dog*",A1:B100,2,False)

Ot use a cell value
=vlookup("*" & a2 & "*",A1:B100,2,False)

--
Regards,
Tom Ogilvy



"sheva" wrote in message
...
Yes, it's working correctly in this way, but i would like to search for
not
exact match too.
Is it possible?

"Tom Ogilvy" wrote:

You probably need to specify an exact match.

=vlookup(A2,#2!A:B,2,False)

--
Regards,
Tom Ogilvy


"sheva" wrote in message
...
I would like to use Serching function for an excel file that would
operate
as
a dictionary. So I wrote words and expressions to column "A" and the
same
in
a foreign language to column "B" (in worksheet #1).
I made an empty cell in an other worksheet (worksheet #2) where I
would
give
the word that I search. I made the following settings: "Function
searching":
Searching value: A2
Table: Worksheet #2!A:B
Number of column: 2

The searching results are mixed and do not give correct value.
What can be the problem?

Yeah, exactly. That was the form, i wanted to: =vlookup("*" & a2 &
"*",A1:B100,2,False)
Thank you for your help!


"Tom Ogilvy" wrote:

Yes, if your willing to get the wrong answer.

I guess it depends on what what you mean by not an exact match.

If you are looking for a word that contains the word dog you can do

=vlookup("*dog*",A1:B100,2,False)

for a word that begins with Dog

=vlookup("dog*",A1:B100,2,False)

Ot use a cell value
=vlookup("*" & a2 & "*",A1:B100,2,False)

--
Regards,
Tom Ogilvy



"sheva" wrote in message
...
Yes, it's working correctly in this way, but i would like to search for
not
exact match too.
Is it possible?

"Tom Ogilvy" wrote:

You probably need to specify an exact match.

=vlookup(A2,#2!A:B,2,False)

--
Regards,
Tom Ogilvy


"sheva" wrote in message
...
I would like to use Serching function for an excel file that would
operate
as
a dictionary. So I wrote words and expressions to column "A" and the
same
in
a foreign language to column "B" (in worksheet #1).
I made an empty cell in an other worksheet (worksheet #2) where I
would
give
the word that I search. I made the following settings: "Function
searching":
Searching value: A2
Table: Worksheet #2!A:B
Number of column: 2

The searching results are mixed and do not give correct value.
What can be the problem?

You didn't specify, but it seems like you're using VLookUp, are you?
VLookUp should have the last optional argument -'range_lookup'- set to
0 to do an exact match.


--
robertdeniro
------------------------------------------------------------------------
robertdeniro's Profile: http://www.excelforum.com/member.php...o&userid=14173
View this thread: http://www.excelforum.com/showthread...hreadid=396097

Yes, i use VlookUp, but my version is not English so i couldn't translate it
correctly.
It is operating well if i choose false or 0 to get exact match, but i would
like to search for not only exact matches.
Is it possible too?

"robertdeniro" wrote:


You didn't specify, but it seems like you're using VLookUp, are you?
VLookUp should have the last optional argument -'range_lookup'- set to
0 to do an exact match.


--
robertdeniro
------------------------------------------------------------------------
robertdeniro's Profile: http://www.excelforum.com/member.php...o&userid=14173
View this thread: http://www.excelforum.com/showthread...hreadid=396097