How to return multiple rows with VLOOKUP If you want to return many rows, you can't use the VLOOKUP function. But you can do the job with the FILTER function.