Autopopulate column values based on pasted data into a table

[CapRavOr]

I need to copy/paste data into a table. From there, I need several columns to autopopulate with data. It works for simple absolute cell references i.e. Date = $O$1, Period = $O$2. However, when I try to use a formula I get an error and when I use other methods, they don't work. I have also tried changing the data type of the cell and columns to no avail. Thanks in advance for any help and let me know if I can provide any further detail.