No problem.

I'm not sure what you're asking with the new question though?
--
Brevity is the soul of wit.


"katencoresl" wrote:

Thanks, Dave. Obviously I don't know what I'm talking about! Please bear
with me! I need to expand on this formula: If there is an "R" in cells
B9:B22, E9:E22, H9:H22, K9:K22, N9:N22, Q9:Q22, T9:T22, or W9:W22, then
display each name found in the cell to the right of the "R" in cells a42:a70
sequentially. HELP?!

"Dave F" wrote:

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!!