Support Board

I find this error when for example I am on Sheet1:

Steps to Reproduce
1. Create a new spreadsheet. Make it a quote spreadsheet.
2. Add an extra sheet to it, I named it "Underlying".
3. Make it a quote spreadsheet too.
4. On the 2nd Underlying sheet, add a few tickers like IBM AMD BYND TSLA AAPL
5. On the first sheet, enter a VLOOKUP formula like this:
=VLOOKUP("BYND",Underlying!B:O,4,FALSE)
6. The formula should work properly.
7. Now right click the cell with the VLOOKUP formula, and click copy formula.
8. Paste formula into a different cell.
9. The formula has been altered to:
=VLOOKUP("BYND",Underlying!B:Underlying!O,4,FALSE)

Editing the formula slightly (for example changing the ticker) creates a #SYNTAX error

A related, but different issue:

Say in a quote spreadsheet I have a formula like this:
=IF($U3=AF$1,$S3,"")

If I copy this formula to the next column, the formula correctly changes to:
=IF($U3=AG$1,$S3,"")

However, the copied formula continues to calculate using the value in AF1 (instead of AG1). Copying and pasting a value or otherwise putting a new value into AG1 causes it to recalculate correctly.