Try this:

Hold down [CTRL] and press [F].......that's a shortcut for <edit><find>
Find what: 15.58
Click the [Options] button
Look In: Values
Click [Find Next]

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"lbbss" wrote:

> I want to search for a value in a cell that comes from a formula. for
> example, if I have =A1*A2=15.58 in cell A3. I like to do a search for 15.5
> and arrive at cell A3. Is that possible? thanks.
>
>
>

I want to search for a value in a cell that comes from a formula. for
example, if I have =A1*A2=15.58 in cell A3. I like to do a search for 15.5
and arrive at cell A3. Is that possible? thanks.

aah, lovely. thanks a lot.

"Ron Coderre" <(E-Mail Removed)> wrote in message
news:110219A1-4389-453B-B1A8-(E-Mail Removed)...
> Try this:
>
> Hold down [CTRL] and press [F].......that's a shortcut for <edit><find>
> Find what: 15.58
> Click the [Options] button
> Look In: Values
> Click [Find Next]
>
> Does that help?
> ***********
> Regards,
> Ron
>
> XL2002, WinXP
>
>
> "lbbss" wrote:
>
> > I want to search for a value in a cell that comes from a formula. for
> > example, if I have =A1*A2=15.58 in cell A3. I like to do a search for
15.5
> > and arrive at cell A3. Is that possible? thanks.
> >
> >
> >