Extract entire rows from list based on criteria

Could you upload some examples, thanks

Originally Posted by wenqq3

Function ,vlookup() or index(match()) can do that.
If know where to extract, can do a formula for you

Please take a look at OP attached xlsx file, maybe you can use it as template