Multiple criteria options determine which name to show as result.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Twishlist - 10 Apr 2007 08:06 GMT

Would really appreciate someone telling me how to display a name (from 10-12
possibles), based on multiple options in a range.
In the column A (range), there is a number of ten or more 4 digit engineer
codes spread across 300+ rows, which I would like to display as engineer
names (in the next column, B).

Reply to this Message

Bob Phillips - 10 Apr 2007 09:05 GMT

Do you have a lookup table of the codes against the names? If so, use
VLOOKUP against that table.

Signature

HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

> Would really appreciate someone telling me how to display a name (from
> 10-12
> possibles), based on multiple options in a range.
> In the column A (range), there is a number of ten or more 4 digit engineer
> codes spread across 300+ rows, which I would like to display as engineer
> names (in the next column, B).

Reply to this Message