Getting data from a huge table to a smaller and organized one.

[Eldernurf]

I have this table with some information that I need to work with. The data is simple, but it has many issues, at least for me, to be able to work with it properly.

Basically, I just need to transfer part of the data from this table to another table (in another order). I failed to use vlookup because I need more than one parameter to search the data (Date, Shift and Sector). Maybe it is silly for experienced users like you guys, but my mind is blown already.... I tried everything I could search/think of.

The problem I am having to get the codes from the source table is that the same code sometimes shows up more than once per date, per shift and per sector. It's also not following a numeric pattern. I couldn't elaborate any combination of formulas to get the info I need.... I am very frustrated right now

I also can't change the format of the source table, because I'm not the one who made it, it has years already, and is constantly updated day by day by a good old man who doesn't know much about computers.


The file is attached, if you need any other information I'll be here.

Thank you already, and sorry for the trouble