Sorry, that's still not specific enough. What do you mean by chart - a cell or a graph? Do you want to lookup the person's name in a table and return the value in the next column? If so in which cell are you typing the name and where is the lookup table?
it is going to be a pie chart for subcontractors lets say; you have lent out 5000 people and only 50 names r shown up on the roster, I want to have the pie chart show that information by just typing a name in the roster sheet