Data Validation and Index Match

[TDC21]

Hello Everyone,

I am trying to create a data entry worksheet that includes a data validation list based on Index/Match values from our Purchase Order Table. I have used data validation to create a drop down list for the PO, and I am trying to create a second drop down list based on matching Part ID's in the PO table against the select ID on the work sheet.

The PO table is set up as,

[TABLE="width: 474"]
<tbody>[TR]
[TD]ROWID[/TD]
[TD]VENDOR_ID[/TD]
[TD]PO[/TD]
[TD]LINE[/TD]
[TD]PART_ID[/TD]
[/TR]
[TR]
[TD="align: right"]153833[/TD]
[TD]RANSTE[/TD]
[TD]35706A[/TD]
[TD="align: right"]1[/TD]
[TD]03750SA517B[/TD]
[/TR]
[TR]
[TD="align: right"]153834[/TD]
[TD]RANSTE[/TD]
[TD]35706A[/TD]
[TD="align: right"]2[/TD]
[TD]05000SB575-N06022[/TD]
[/TR]
[TR]
[TD="align: right"]153835[/TD]
[TD]RANSTE[/TD]
[TD]35706A[/TD]
[TD="align: right"]3[/TD]
[TD]03750SB171C71500[/TD]
[/TR]
[TR]
[TD="align: right"]153836[/TD]
[TD]AMESTE[/TD]
[TD]35705A[/TD]
[TD="align: right"]1[/TD]
[TD]08750SA387112[/TD]
[/TR]
</tbody>[/TABLE]

The worksheet I am trying to create has the following format

[TABLE="width: 450"]
<tbody>[TR]
[TD="class: xl65, width: 91"]INVOICE[/TD]
[TD="class: xl65, width: 79"]PO[/TD]
[TD="class: xl65, width: 152"]PART ID[/TD]
[TD="class: xl65, width: 64"]QTY[/TD]
[TD="class: xl65, width: 64"] COST[/TD]
[/TR]
</tbody>[/TABLE]
data entry Validate Validate Data entry Data Entry

The desired result would be to enter PO 35706A in the worksheet and have a drop down for the part ID column that would include the matching parts from the PO table. I have played around with using some index match array formulas as the source in data validation but with no luck. Is something like this possible?[TABLE="width: 474"]
<tbody>[TR]
[TD="align: right"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]