How to search for data independently from sorting

[Hannes_8]

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 sheet 1. But I also want to be able to sort in sheet 2 and the value of Item X remains the same in sheet 1. The Items all have their unique "serialnumber" I am searching for.

I have attached an example, but since I`m from Germany I have to use "SVERWEIS" instead of "VLOOKUP".

I hope my problem definition is understandable and that you can help me out.

Thanks a lot and best regards

Hannes

[#2 · Accepted solution]

@Hannes_8 

Add FALSE as 4th argument:

=VLOOKUP(E4,Tabelle2!I:K,3,FALSE)

=SVERWEIS(E4;Tabelle2!I:K;3;FALSCH)

[#3]

@Hans Vogelaar 

Thank You very much ! It works perfectly.