Can you search for a value output by a formula?

R

Ron Coderre

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
 
L

lbbss

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.
 
L

lbbss

aah, lovely. thanks a lot.

Ron Coderre said:
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 said:
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.
Click to expand...
Click to expand...
 
Top