*Example*

```
2 2 =A1*B1
```

produces correct result, but when copied to a new row the formula make static reference to Row1.

I tried this and it works

```
2 2 =PRODUCT(LEFT)
```

BUT must be able to **explicitly** select which column in the formula.

**Can anyone tell me a specific keyword or have some
other formula to use a cell reference on the same row as the formula?**