Thank you for the formula. I have adjusted your formula a bit to serve my purpose. I have another question. If I have another pull 2 worksheet in consist of more product family, so my dropdown list now expanded. How can I retrieve data from 2 lookup worksheets now. I understand that why I don't put 2 pull worksheet together, this data I retrieve automatically via smartview so it is limited in columns I have to seperate them into 3 different spreadsheet to look up entire product family. I attached a new sample worksheet with new dropdown list. Please help, thanks.Formula Test.xlsx