• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Vlookup value and display Multiple result in rows

Dear Experts,

Need help to create complaint tracker where if status is pending to show all complaint which are pending in separate rows.

Cell B9 is status as pending and B11 onward the data for pending should display by formula

file enclsoed.
 

Attachments

  • Complaint Tracker.xlsx
    9.7 KB · Views: 5
Mohamed Sameer Kazi
Your files B9 and B11 are ... empty.
Could You use Filter to get Your needs?
... Use Cell H4 to Filter needed rows.
 

Attachments

  • Complaint Tracker.xlsx
    11.1 KB · Views: 4
Hi Vletm,

thanks for your quick reply, will be showing having pending status on other sheet, so i want pending complaint to be shown below in B21

really appreciated your support.
 
Mohamed Sameer Kazi
a) Your files B9 and B11 are ... empty.
b) Do You have more than three rows data? If more then ... cell B21 ... yes!
As well as, then someone has take care that there are enough 'formulas'. ... auto show.
c) Suddenly results to the other sheet.
d) Select from this file Result-sheet.
 

Attachments

  • Complaint Tracker.xlsb
    17.8 KB · Views: 7
Dear Vletm,

The issue is if the status for complaint change to closed, the pending should not be shown in pending list.

Sheet result is copy paste for pending status.

i hope will get some vlookup formula or Index and match with array to show multiple result in rows.
 
Mohamed Sameer Kazi
In the beginning - You needed only one 'Status' to show, based Your sample result.
I added 'controller' so select which 'Status' will show in Result-sheet by 'auto show'.
 

Attachments

  • Complaint Tracker.xlsb
    18.5 KB · Views: 10
Back
Top