Forum Discussion
Gary_Bostock
Nov 20, 2020Copper Contributor
Formula error in link to another spreadsheet
I am trying to fetch data from one spreadsheet into another. no matter which lookup formula I use, I get an error: There is a problem with this formula. Not trying to type a formula? When the f...
SergeiBaklan
Nov 20, 2020Diamond Contributor
In general formulas do not work wit links, they work with values and references. It's not clear what you try to do - create a link on the cell in another workbook; or create formula which takes value from the cell in another workbook based on some parameters how to find such cell?
- Gary_BostockNov 25, 2020Copper Contributor
SergeiBaklan I want to use a referenced cell value in spreadsheet 1 to find the cell content next to the corresponding value in a column in spreadsheet 2.