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.

--
Tim Zych
www.higherdata.com
Compare data in Excel and find differences with Workbook Compare
A free, powerful, flexible Excel utility


"tgcali" wrote in message
...
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