Hey, i am looking to transfer a pokemon spreadsheet I made in excel to coda as i feel it will be much more versatile for viewing. However many cells in my spreadsheet have formulas that reference a different cell in the same column. How do you do that in Coda?
As an example:
column name: # of candies
column values: 10, 12, 12, 25, 28, 28, 28
I want the second 12 and second and third 28’s to derive their value from the previous entries of the same value. in excel i do it currently with this formula: =VLOOKUP(“Caterpie”,$B$1:$E$153,4,FALSE) where the only data I change when necessary is the name between the “”