Beatrice
Board Regular
- Joined
- Sep 17, 2019
- Messages
- 85
- Office Version
- 2019
- Platform
- Windows
I would like to create a table for user to look for the most similar Product Description.
Let say, they need to input 3 criteria:
1. text from a drop down list << need exact match
2. text from a drop down list << need exact match
3. number only << FIVE of the nearest match
* database will be stored as separated worksheets and locked for access control
* Excel version 2007
I tried below, but not working:
1. Data> Advance Filter
2. ARRAY Formula (index, match ...)
How can I make it happened?
Many thanks in advance for helping
Let say, they need to input 3 criteria:
1. text from a drop down list << need exact match
2. text from a drop down list << need exact match
3. number only << FIVE of the nearest match
* database will be stored as separated worksheets and locked for access control
* Excel version 2007
I tried below, but not working:
1. Data> Advance Filter
2. ARRAY Formula (index, match ...)
How can I make it happened?
Many thanks in advance for helping