How to reference cell?

[tgcali]

Hello,

Here is what I need to do.

If cell N2="YES", I need the contents of cell K2 to populate in cell B2. I
need to be able to extend this down for 25 rows. Any ideas how I can do this?

As always, help is greatly appreciated.

tgcali

 

[Tim Zych]

In B2 type

=IF(N2="Yes",K2,"")

Modify the "" to whatever you need, e.g. "Not Found" or whatever. If N2 is
not Yes, the above will return an empty string.

Position the cursor toward the bottom right of B2 until it turns into a
crosshair, then click to grip the cell, drag down as far as you need.