Thanks, Ron. Works beautifully! What you and Duke have provided is going to
be very useful!

"Ron Coderre" wrote:

UM...how about i give a formula that actually works and does what you want.

For text in B1 and a number in C1

D1: =IF(COUNTIF(B1,"*book*"),C1,0)

I hope that helps?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Ron Coderre" wrote:

Perhaps something like this:

For values in A1 and B1

C1: =IF(COUNTIF(B1,"*book*"),C1,0)
Copy down as far as needed.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro


"Elaine" wrote:

In col B I have some entries many of which have the word 'book' in some form
-- eg. notebook or bookmark.

In col C I have some numeric codes -- 1, 2, 3 etc.

If a cell in Col B contains the word 'book' I would like in Col D to show
what is in Col C; if the cell in Col B does not contain the word 'book', I
would like to put a 0 (zero) in Col D.

Thanks for your help!