List Item Batch based on data with multi duplicates

[kaoticone]

Hi There.

Im trying use the list function for batch number based on their Material code. The issue is we have multiple Material codes that have the same naming but different batch numbers

I have all the data in a worksheet (that gets pulled form SharePoint) named Materials2.
The main sheet is called Lab Test Sheet Template
Example on the main sheet in column A starting at cell 28 to 52 I select the Material Code say CM600. However CM600 has multiple Batch Numbers say lot01 lot02 and lot03 located in column F in the materials2 worksheet
I want to be able to select one of those lot numbers. Same for the next cell down Cell A29 Material Code CM302 and then select its Batch Numbers. However what I've tried doesn't work.


cheers for any help

Thanks
J

 

[kaoticone]

Mate your a legend . Thanks Very much for help with this. you have been a life saver.

Works perfectly.

Cheers
J.

 

[myall_blues]

You’re welcome. Thanks for the feedback.