Can I Auto populate cells based on value in another cell

[Rednecknerd]

Hi,

I need to fill several columns of flow requirements based on a pn entered into a cell.

What i need to happen is the pn cell gets filled, then the flow requirements fills in from data on a second sheet.
I have included the workbook i am using. It has sample data in it. The blue cells are the ones i need to have auto populated.
Sheet 2 has the data that would go into the cells.

Not sure how to proceed.

[protonLeah]

For the As Received data table:

Create named ranges for each table on sheet 2.
Create named range ("pn") for cell E1 on sheet 1
Create named range for the list of named table ranges (sheet 2)

Create dropdown validation list in cell E1/pn using list of named table ranges

Formula for Cells A3:C12, L3:L12:

Please Login or Register  to view this content.

[Rednecknerd]

Thanks.

With just a little tweaking this will be perfect.
It didn't work for me when i tried, but after reviewing your example i found my error.