Jan, try this, =IF(B10,A1,"")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Janwillem" wrote in message
. ..
Hi there.

i have something like this:

A B C D
1 hello 1
2 test 0
3 bye 1


Now i want to display hello at D7 when B10

So the output should be:

A B C D
1 hello 1 hello
2 test 0
3 bye 1 bye

How can i do this?

thanks,

Jan Willem