<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:ming.v.hua@qq.com" title="Ming Hua <ming.v.hua@qq.com>"> <span class="fn">Ming Hua</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Search did not find text given from vlookup"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136518">bug 136518</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>ming.v.hua@qq.com
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEEDINFO
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Search did not find text given from vlookup"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136518#c3">Comment # 3</a>
on <a class="bz_bug_link
bz_status_NEEDINFO "
title="NEEDINFO - Search did not find text given from vlookup"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=136518">bug 136518</a>
from <span class="vcard"><a class="email" href="mailto:ming.v.hua@qq.com" title="Ming Hua <ming.v.hua@qq.com>"> <span class="fn">Ming Hua</span></a>
</span></b>
<pre>(In reply to reikenberg from <a href="show_bug.cgi?id=136518#c2">comment #2</a>)
<span class="quote">> This should be default for the normal search or give the option to switch to
> values too.</span >
There is already an option.
In the "Search and Replace" dialog, on the bottom right, there is a drop-down
list labelled "Search in:", and the options are: Formulas, Values, and Notes.
The default choice is Formulas.
Changing it to Values make it possible to search for the VLOOKUP() results in
your example file for me. Does it work for you?</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>