Looks fine, what problem are you experiencing?

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"sedonovan" wrote in message
...
Can you tell me what's wrong with this formula please

=if(sheet1!A2<"",sheet1!a2,"")

that is (being in sheet2)
if there's a value in A2 on sheet1
copy it/reference it on sheet2
if not, leave blank.

Many thanks,
Suzanne