You can use the INDEX and MATCH functions together to return multiple corresponding values. Here's how:

1. First, select the cell where you want to display the first corresponding value.
2. Type the following formula:
   Formula:

   =INDEX(range,MATCH(lookup_value,lookup_range,0)) 

   - Replace "range" with the range of cells that contains the values you want to return.
   - Replace "lookup_value" with the value you want to look up (in this case, the name you're searching for).
   - Replace "lookup_range" with the range of cells that contains the names you're searching for.
3. Press Enter to display the first corresponding value.
4. To display the next corresponding value, select the cell below the first corresponding value and type the same formula, but change the "MATCH" function to search for the next occurrence of the lookup value.
   - For example, if the first formula was
   Formula:

   =INDEX(range,MATCH("John",lookup_range,0)) 

   , the second formula would be
   Formula:

   =INDEX(range,MATCH("John",lookup_range,MATCH(lookup_value,lookup_range,0)+1)) 

5. Repeat step 4 for each additional corresponding value you want to display.

Note: If there are no more corresponding values to display, the formula will return an error. To avoid this, you can use the IFERROR function to display a blank cell instead of an error message.