lisette luik
New Member
Hey!
I have a problem that I literally have no idea how to solve.
Employees have expences, salary & extra salary for doing extra work. Inputs (e.g salary) should be dynamic because employees get paid differently & for the job they have done, so the inputs are always changing it's place but are always defined by the name (Töötaja). =getpivotdata & =vlookup doesn't seem to work
nTo be precice, =getpivotdata worked perfectly but only when input didn't change its place. So the question is: how to get data from Sheet Palgaarvestus F to Sheet Töötajatele_maksmiseks C and from Palgaarvestus N to Töötajatele-maksmiseks E? Excel should find data by name (Töötaja) because only sheet Töötajatele-Maksmiseks is still, other sheets have random inputs Any ideas?
I have a problem that I literally have no idea how to solve.
Employees have expences, salary & extra salary for doing extra work. Inputs (e.g salary) should be dynamic because employees get paid differently & for the job they have done, so the inputs are always changing it's place but are always defined by the name (Töötaja). =getpivotdata & =vlookup doesn't seem to work
