changing formulas to values so that they will be recognized by Find and Replace

[akeane]

Hello,

Here is my dilemma:

I have a list of patient names in Column A on Sheet 1 that will b
updated over time.

I have linked Column A on Sheet 2 to Column A on Sheet 1 so that an
changes made to the list on Sheet 1 will automatically show up on Shee
2.

However, when I need to search for a patient name on Sheet 2, I canno
use the "Find" feature because it is reading the formul
(='Sheet1'!A1), and not the value (Patient Name).

I thought about using a second column on Sheet 2 to convert th
formulas to values, but this column is not automatically updated when
new entry is made (i.e., an new patient is added to the list on Shee
1).

Any suggestions?

I appreciate any tips you can offer!

Thanks,

Angel

 

[swatsp0p]

When you use the FIND feature, I am assuming you are referring to th
Edit>Find (CTRL+F) tool.

If that is correct, you can set the Options to Look in: Values. Thi
will then FIND the name that is returned by the formula, not th
formula itself.

To do this, press CTRL+F, enter the name to look for in the Find Wha
box, then click on Options>>. The Find and Replace box will enlarge t
display several options. Click the down arrow in the Look in: box an
choose Values. Click Find Next.

Does this work for you?

Bruc

 

[akeane]

Yes - thank you so much for your help! I must admit I feel a bi
sheepish about there being such an easy and straightforward solution

 

[swatsp0p]

Angela: I'm glad this worked for you. Thanks for the feedback, it is
always appreciated. No need to feel sheepish, as Excel has thousands
of 'hidden' ways to do things. I'm learning new stuff every day!

Cheers!

Bruce