Multi-column search to return a single value

I have a 2 worksheet workbook with tabs title DEST and SOURCE.
I have to search all the rows in the SOURCE tab matching multiple column values to return the value for SOURCE Default Code.

In DEST worksheet, Row 1 I have to search and find the SOURCE row that matches on the columns titled Name, Vendor Code, Karate, Primary Material, Width and Ring Size. Once a match is found I need to return the value in column A, Default Code, to column D, Source default Code, on the DEST tab

Thanx in advance for your help!
This forum is awesome!

Is this an Excel question... or Googlesheets... or what?

There are FAR too many rows. Cut it down to 10-20 rows. Make sure that there is AT LEAST one or two matching values and repost in this thread.

OK. Repost with a sensible sample file & I will move the thread for you, away from the Google sheets sub-form, where you posted it.

You POSTED it in the Google sheets sub-forum. I MOVED it to an Excel formula sub-forum.

You often get people who post Excel sheets and fail to tell us that they want it to work in Google Sheets. That is why I asked the Q in the first place....

Originally Posted by ara.darakjian

If you look above, the post breadcrumb shows I posted it to excel formulas and functions

No you did not. I have already told you that I moved it after you clarified what solutuion you wanted.

I can no longer see the criteria you want to use to return the desired results!!

We'll see!! I'll have a look.

When I asked you to cut down the sample to a sensible size, I also asked you to ensure that there was AT Least one row that matched. Which row(s) are supposed to match. My formula returns an error for all rows.

OK. I'll check that one. I also introduced a Match of my own (yellow rows). This worked:

=IFERROR(INDEX('Product details - SOURCE'!$A$2:$A$50,MATCH(1,INDEX(('Product details - SOURCE'!$E$2:$E$50=F2)*('Product details - SOURCE'!$B$2:$B$50=G2)*('Product details - SOURCE'!$N$2:$N$50=M2)*('Product details - SOURCE'!$H$2:$H$50=N2)*('Product details - SOURCE'!$K$2:$K$50=S2)*('Product details - SOURCE'!$M$2:$M$50=U2),0),0)),"")

I'll double check your one in a second.

In your "matching data":

Source says 10k Rose Gold for Primary Material and blank for karetage.

Destination says Rose Gold for PM and 10 k for karetage.

That's why nothing was found. Anyway... does my formula (seem to) do the job?

You're welcome.

---

It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

Finally, if that takes care of your original question, please select "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.