Login Page - Create Account

Home >> Support Board

Support Board

Date/Time: Thu, 02 May 2024 21:52:23 +0000

How to Post a Message for Support

Post From: Error copying formula referencing another sheet

[2021-01-08 02:31:40]
[Go To First Post]
ijtraderji - Posts: 6
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.