What is the maximum number of entries in sheet2 that you might have
for any one claim? 10? 20?

If these are then displayed in Sheet1 for the claim number entered,
what do you want to happen then? I don't understand what you mean by
"... let the user decide which one of the entities to pull in ..."

Pete

On Apr 10, 5:20*pm, Leslie wrote:
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.