Not sure what a circular reference has to do with this. =IF(B9="R",C9,"")

Enter this formula in the cell for which you want the value of C9 to appear
if B9 = R.

Dave
--
Brevity is the soul of wit.


"katencoresl" wrote:

I have 2 columns labeled "Code" and "Name". I want to create a link based on
the following criteria: If cell B9 contains the code R, display the name in
cell C9 in cell x within the same worksheet. Does that make sense? Any help
would be appreciated!!