I have a sheet1 that has the following dataset A

```
ColumnA:    ColumnB:      ColumnC:      ColumnD:

Row1:        June 1        June 2        June 3
Row2:
Row3: A      Apple         Apple         Orange
Row4: B      Orange        Orange        Orange
Row5: C      Orange        Apple         Orange
Row6: D      Pear          Apple         Pear

```

In that sheet I have the following table

```
       Consumed fruits
        **June 1**             **June 2**            **June 3**
     Apple Orange Pear      Apple Orange Pear     Apple Orange Pear

A    True                   True                        True
B          True                   True                  True
C          True             True                        True
D                 True      True                               True

```

Where for each cell I add the following code that pertains to datasetA

For June 1, A, Apple

```
=IF(B3="Apple","True","")

```

June 1, A, Orange

```
=IF(B3="Orange","True","")

```

June 1,A, Pear

```
=IF(B3="Pear","True","")

```

But when I drag the formula to the next date (June 2, A, Apple), it changes to

```
=IF(B6="Apple","True","")

```

Instead of

```
=IF(B4="Apple","True","")

```

Is there anyway to keep the query cells constant for 3 formulas, before incrementing just one query cell up in the next 3 formulas?