search for value based on 3 conditions from duplicated ( multiple ) values in excel

hello , i wish to have your help for the attached file.
i have table have many columns with large amount of duplicate values.
column A have many duplicate values but the other columns ( B,C,D, etc ) will have different values.
I need to search I the  table for value mentioned in column named “ code “ based on 3 conditions mentioned in the list

hope its clear in the attached file

thanks in advance
M. SaadAsked:
Who is Participating?
Ejgil HedegaardConnect With a Mentor Commented:
See attached with reversed formula in column N.
Ejgil HedegaardCommented:
See attached.
I have added a column for the code search in the list, so you can compare to code.
M. SaadAuthor Commented:
thanks alot for your reply , but i am really sorry that i was not cleare . i need the result in column N to be automatically with formula.
other meanining, i want to find the code match the data in the table named " list " from the table named " table 1".

hope its cleare now and really sorry for this mistake
M. SaadAuthor Commented:
thnak you very much , this is what i need
have  a nice day
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.