How to reference cell?

T

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
 
T

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.
 
Top