In D9 enter this formula

=IF(B9="R",C9)

But you may want to trap for C9 having no value.

=IF(AND(B9="R",(C9<"")),C9,"conditions not met")


Gord Dibben MS Excel MVP


On Thu, 25 Jan 2007 10:16:00 -0800, 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!!