Can you search for a value output by a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Ctrl-H crashes Excel 2002. 8
Edit > Find option mysteriously malfunctioning 1
Lookup function to cell containing multiple values 3
macro on different reports CTRL+F in formula 2
Chrome keyboard shortcuts 2
Want to remove CTRL-F giving full screen 1
Macro that copies values from column A (from formula) to B (paste value) 1

Back
Top