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,
<tbody>
</tbody>
The worksheet I am trying to create has the following format
<tbody>
</tbody>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?
<tbody>
</tbody>
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,
| ROWID | VENDOR_ID | PO | LINE | PART_ID |
| 153833 | RANSTE | 35706A | 1 | 03750SA517B |
| 153834 | RANSTE | 35706A | 2 | 05000SB575-N06022 |
| 153835 | RANSTE | 35706A | 3 | 03750SB171C71500 |
| 153836 | AMESTE | 35705A | 1 | 08750SA387112 |
<tbody>
</tbody>
The worksheet I am trying to create has the following format
| INVOICE | PO | PART ID | QTY | COST |
<tbody>
</tbody>
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?
<tbody>
</tbody>
