VLOOKUP with Multiple References

Hello,

I am trying to accomplish a task that uses the VLOOKUP function to retrieve data from another worksheet. The problem I am having is that it will only return one row of data.

In the formula below, there are multiple rows that contain the $C$4 reference.
I would love to figure out how to return all the rows that contain that
C$4$ reference. I hope this makes sense...??? Thanks!

=VLOOKUP($C$4,'Hot Zone Customers'!$C$2:T561,14,0)