vlooking shows only the first match. How to keep on looking?

Originally Posted by Craig K.

I don't see the utility in this however. May as well save the trouble of creating this formula and just use filters/sorts.

You may want the extracted data to appear on a different sheet or in a different file.

You might want this to be dynamic based on other user inputs or other formulas.

You might want to use this data as the selections in a drop down list.

This type of question is asked frequently.