Matching two criteria and returning another (Similar to an Index Match Match in Excel)

[tom05]

Hello,

I am looking to replicate what I would use an INDEX/MATCH/MATCH for in Excel.

I have two sheet, one containing values and another containing material numbers. Both have the same document number and item numbers.

I need to match the document numbers and line numbers between the two sheets and return the material number to the first sheet.

Where the document number has more than one item, but a different material, I need to match the unique line to return the correct material.

Attached is some example data.

Thank you in advance.

[JosephSerpis · Accepted solution]

Hi @tom05 check out this example workflow. Let me know what you think?

[atcodedog05 · Accepted solution]

Hi @tom05 ,

I think what you are looking for is join on multiple keys.

Here is a workflow

Joining on 2 keys 

Output

Hope this helps : )

Please let us know how we can help you further.

If this helps please mark it as a solution.

[tom05]

Great, thank you. I was trying to over complicate things.

[atcodedog05]

Happy to help : ) @tom05 

If this helps can you please mark the post as solution and like the posts.

[atcodedog05]

Thank you @tom05 

Cheers and Happy Analyzing : )