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 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