Formulas wile working with few sheets information
Hi,,, below is an example of a work book I’m using, In this example I’m using 2 work sheets but normally it’s more, in work sheet 1 I have information and in column 1 I have a formula been used, in sheet 2 I have filled information from sheet 1, you may see I have coloured them using conditional formatting, to the right on sheet 2 I want to creat a formula that will pull the correct iteams under the correct section,colour, I’m using, in cell I22 I’m puting =if(A3=”WT C”,A3:A4,””) when I enter this it returns nothing, well nothing that I can see, no error no box saying I’m doing it wrong,
Hi,,, below is an example of a work book I’m using, In this example I’m using 2 work sheets but normally it’s more, in work sheet 1 I have information and in column 1 I have a formula been used, in sheet 2 I have filled information from sheet 1, you may see I have coloured them using conditional formatting, to the right on sheet 2 I want to creat a formula that will pull the correct iteams under the correct section,colour, I’m using, in cell I22 I’m puting =if(A3=”WT C”,A3:A4,””) when I enter this it returns nothing, well nothing that I can see, no error no box saying I’m doing it wrong, Read More