Index + match

I have a problem and I have no idea how to solve it, since I'm not really into MS-Excel.

So, I have 2 different sheets with 2 different values. I need to compare N my cols A - J from sheet 1 against B - K of sheet 2 and if all columns match, to fill in the the Value of col A from sheet 2 into col K of sheet 1

I'll provide a quick example:

table 1

\1

table 2
\1

So, to clarify:
In my first example of table 1: I would need the value of "Profile1" same goes for row 2 + 3
In the 4nd example I'd need Profile 3.

I tried it with different functions like SVERWEIS, WENN but I couldn't figure it out. I'm using a german set of functions, but I can translate the functions by myself, I guess.

I added the excel-sheet. The formular has to be set into Sheet1 -> Col K

Welcome to Excel Forum.
The following array entered formula* seems to work as it finds instances of all Tarifprofils except 3 and 7 although most rows don't seem to match. It would be helpful to know what the expected values are in at least a few of the cells in column K:

Formula:

Please Login or Register  to view this content.

I don't know how the different functions, IFFEROR, SMALL and ROW, translate into German, nor whether your version of Excel uses semicolons ( ; ) instead of commas (,).
Edit (sorry I missed saying this originally): To activate an array entered formula press the Ctrl, Shift and Enter keys simultaneously while the cell is in edit mode (F2) and before double clicking to copy down.
Let me know if you have any questions.

I have lurked here... cos I did't understand the logic of what was going on. now that someone else has jumped in.... I'll ask my Q. How can the expected result for Tabelle 1, K2 be Profile 1, when Profile 1 contains a blank against Hotspot Flat 3M in Tarifprofil E2????

@Glen I apologize that I omitted the formula is CSE entered. K2 is blank, as are most of the cells in column K, the instance of Profile 1 occurs in row 77.

My Q was for the OP, not you. I couldn't understand the request....

Hey guys, you are right. The Answer is totally fine.
@glenn: I made a mistake, you are totally right. The 1st column shouldn't show anything since not all fields are matching.

One last question though, if I copy the formular into my sheet, it doesn't work. When I copy the formular in K2 and pull down to the other rows,
it seems that it is not workig as intended. Do I have to adjust it somehow?

Also, when reopening the file and I insert this formular exactly:

Formula:

Please Login or Register  to view this content.

it shows Profil1 in row1, Profil2 in row2 ... Profil7 in row7 and then it keeps beeing empty.
I think it has something to do with the curly brackes it is showing?

// just saw the further explaination from the answer with CTRL + SHIFT + Enter

Glad that the solution works, thanks for the for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.