if c13=1, then use a number from a seperate sheet (column c) which is
dependent on c17??

Hi

not really sure what you're after here maybe
=IF(C13=1,Sheet1!C17,"")

which says if C13 = 1 return the value from sheet1 c17, otherwise return
nothing.

Hope this helps
Cheers
JulieD

"niit_train12" wrote in message
...
if c13=1, then use a number from a seperate sheet (column c) which is
dependent on c17??