I have been struggling with this for a while and you haven't let me down before!!
I have 5 lists, each with unique values. What I need is if a given cell starts with one of these unique values, indicate which list it comes from?!
I have attached a file for you to look at.
on tab 'All' call 'A3' I need a TW to show in that cell this is because cell 'E3' text 'A CARBON' begins with 'A C' which is included in TW list on tab 'Lists'
Thank you for your help