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?