please respond to my clarification questions of 082307 thanks
--
claudia


"bj" wrote:

use a helper column in shhet one (c?)
in c1 enter
=if(iserror(vlookup(a1,Sheet2!A:B,2,0),b1,vlookup( A1,sheet2!A:B,2,0))
copy and paste down to the end of your data.
select column C
copy
select column B paste special values, delete column c


"lilleke" wrote:

Excel 2000 - this is under help - keyword-null and doesn't work and I need it
to work or am I reading wrong?

I hv 2 databases w 2 col 1 for owner name and 1 for financial ofcr name

I need to cut/paste fin ofcr name into owner name cell if there is a
financial officer name because I would rather mailer go to fin ofcr. There
isn't always name in fin ofcr col. I scroll until I find fin ofcr name,
cut/paste to col to the left and overwrite the owner's name with fin ofcr
name. about 10 fin ofcr names per visable screen.

Painful on mouse hand.

I want to highlight maybe whole fin ofcr col or at least visable page
cut/paste and overlay col to left with fin ofc name but not make other cells
blank. currently when I do this fin ofcr name is pasted and all other blank
cells are pasted as blanks also.

If copied blank cell overlays not blank cell I want blank cell not copied.
Please help.
--
claudia