Hi Experts,
I have existing excel which uses index and match functions to get appropriate search results. But here i want to display all matched records . How to do this? Can you please help me with modified excel to achieve this?
Hi Experts,
I have existing excel which uses index and match functions to get appropriate search results. But here i want to display all matched records . How to do this? Can you please help me with modified excel to achieve this?
Like this maybe?
Formula:Please Login or Register to view this content.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Formula:Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Yes exactly. Thank you for quick response. But it should display values properly in those coreect cells. Also there are - coming below cells. Also its not listing all the products from selected tab. Can you attach the fixed excel filw?
See the attached
Hi John , Thank for Quick reply . But now it lost the control over Quantity column . Its displaying all the values for that product. Can you help me with that ?
Perhaps the following:
1. For MRP:Formula:Please Login or Register to view this content.
2. For DLP:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks