Forum Discussion
Solved
How to search for data independently from sorting
Hello Community, do you have any any ideas how I can get the same data from sheet 1 to sheet 2 even when I apply the sort function in sheet 2 ? E.g. I need the value of Item X from sheet 2 in sh...
Add FALSE as 4th argument:
=VLOOKUP(E4,Tabelle2!I:K,3,FALSE)
=SVERWEIS(E4;Tabelle2!I:K;3;FALSCH)
Add FALSE as 4th argument:
=VLOOKUP(E4,Tabelle2!I:K,3,FALSE)
=SVERWEIS(E4;Tabelle2!I:K;3;FALSCH)