Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

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
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)

We’ll send you updates on this idea

Imdad Pasha shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base