# I wanted to extract the data from sheet1 and sheet2 with respect to date using if condition,

I have 3 sheets named as Generalized sheet, sheet2 and Sheet3,

To copy data from sheet 2 and 3 based on the date If condition is being used.

when the 1st if logical value is false another if condition is used (nested if).

=IF(Sheet3!$A2=Generalized!$K$1,Sheet3!$A$2,IF(Sheet2!$A2=Generalized!$K$1,Sheet2!$A$2," "))

Sheet 3 has data in 5 cells hence the above formula is working fine.

When the formula is dragged the cell count increases and hence the formula goes wrong.

Please help me in solving this

Solution.

can we get an update to unlock the cell once the logical condition is false.

**1**vote