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

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.

Join

Accepted answers

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

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.