Ordering certain entries in a range, matched against another range

[Babymech]

I've got a fairly basic problem that I've run up against a number of times
and never satisfactorily solved. Basically I want to fill a column C with the
entries from column A if Column B fills a certain criterion. To give an
example, I want to be able to list in column C all 'names' that are listed as
'internal' type-wise.

Name Type Internal Projects
1 NameA Internal NameA
2 NameB External NameE
3 NameC External
4 NameD Misc.
5 NameE Internal

The Name and Type columns will extend indefinitely downwards; I would also
want to create a column for External Projects and Misc. of course. Ideally I
want to do this without having to resort to using a hidden column for each
Type, since there are very many possible Types. If I do have to use a hidden
column, how would that be done in the best way?

Thanks!

 

[Babymech]

Sorry for the Post failure - I meant to put this in the Excel forum. If
someone has the power to delete this, that owuld be great.