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

A

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
 
S

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
 
Top