Is it possible in JMP to re-create the "INDEX(MATCH()) formula combination available in Excel?

[#1]

Is it possible in JMP to re-create the "INDEX(MATCH()) formula combination available in Excel?

This is the table I am working on:

 

In the column “Result” I want to put a particular value which respond to this rule:

• If (“Y” is not 0) Return the “X” value contained in the cell with the same “NAME” as the current cell and with “ID” equal to the index indicated in “Y” (in this case 5).
• Basically in the first row I want that “Result” contains “4.7”

@txnelson  you are the JMP wizard Do you believe it is possible?

Cheers

[#2]

Great! Thanks Jim, modified a bit and works fine.