I have two worksheets in a single workbook. My fisrt worksheet contains
claim numbers and my second worksheet contains a link file listing all claim
entities and sorted by claim number. There are multiple claim entities per
claim. I am trying to figure out how I can use the vlookup to find all the
entities for a particular claim and then allow the user to select from the
vlookup which one they want to use.

worksheet 1
CLAIM NO
104068

worksheet 2
CLAIM NO ENTITY
2387 Smith, John
183778 All State
183778 Johnson, Alisa
104068 Farm Bureau
104068 Goodloe, Milford
104068 Thompson, Nancy

Using the above example, when the user enters 104068 on the first worksheet,
I need a function in the next cell to possibly show the user all the entities
from worksheet 2 that match that claim number and then let the user decide
which one of the entities to pull in.