I want to use Lookup formula in Table Sprint. I want to lookup my previous row of a table. Then want to find out what value hold in my previous row and put that value in this row.
Basically want to do some accounting stuff.
@akshaytax2014, Please add the link dropdown field and the derived field (select the field you want to display in the derived field while adding it) in the same worksheet where you want to perform the lookup. Then, fill in the link dropdown field so that the derived field will be automatically populated.
Best,
SB