VLOOKUP error

[Simon1]

I have a table with a few spread sheet formulas that I've been using in an app for a long time.

I now need this sheet in another app.

All the spread sheet formulas are working except for the VLOOKUP

In appsheet the formula is  VLOOKUP(RC[-1],C[-14]:C[-2],13,false)

When I add data from the new app it puts the formula in this format VLOOKUP(N15309,C[-14]:C[-2],13,false) rather than the usual spread sheet format, VLOOKUP(N2,A:M,13,false) and it shows #ERROR! 

The other formulas are added as normal spread sheet formulas.

I regenerated the table. 

I copied the VLOOKUP from the other app and pasted it in the spreadsheet formula in appsheet.

How can I get it to work?

Thanks

[Derinko]

try avoiding spreadsheet formulas, you can use lookup() as a substitute

[Simon1]

Unfortunately it needs to be a spreadsheet formula as it changes when a different row is edited.

But it can't be a virtual column as I also use it to work with the data in the google sheet

[Steve]

Best to avoid populating the Spreadsheet formula setting yourself in the app column's configuration. Instead, remove the app column's Spreadsheet formula altogether, apply the desired formula in the spreadsheet, the regenerate the app table's columns to prompt AppSheet to discover the spreadsheet formula.

[Simon1]

I blanked the spreadsheet formula in appsheet and regenerated.

All the other spreadsheet formulas are there, but this one isn't. it's still blank.

[Simon1 · Accepted solution]

I had different spreadsheet formulas in some cells in the column.

When I made them all the same and regenerated it has worked.

[Steve]

Well done!

👍