G Guest Jan 28, 2005 #1 if c13=1, then use a number from a seperate sheet (column c) which is dependent on c17??
J JulieD Jan 28, 2005 #2 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
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
