Capture.PNG
Say this is the table in sheet 1, given the condition of output in sheet 2 is when PIC=Ali, all the relevant rows related to Ali will be returned in sheet 2. Result in sheet 2 will be as shown below
2.PNG
Any idea what formula to use? I have tried vlookup, if statement, index. All didnt work for me