arifanmol, Good morning.
Try to put in A4 --> =IF(D7=4, OFFSET(D6,-1,0), "Nothing")
The "FALSE" is appearing because what to do is missing in the second argument of the IF function.
I put the word Nothing to fill in the missing argument.
Please, tell us if it is what you need.
have a nice day!