VBA or "in cell" data conversion?

[Dougmeister]

I have a "simple" problem, and I am not sure whether to tackle it in VBA code (which I know will work, but may take longer) or with some simple, yet elegant, Excel tricks.

Let's say I have a table like this:

I will be receiving an input file with hundreds of rows of *ONLY* the first row of data ("Name").

*Some* of the Names will match the above data; many will not.

IF a name in a given row in the input file matches a name in the above chart, THEN I need to assign to that Name the appropriate "Affiliation".

There are no other "Affiliations" for the purpose of this exercise, so I will have to add an "Other" category.

Did I explain the problem clearly enough? It not, please ask I and I will do my best to correct myself.

Thank you in advance.

 

[Joe4]

Sounds like you may be able to use VLOOKUP in order to do what you want (see: https://exceljet.net/excel-functions/excel-vlookup-function).
You can handle the unmatched ones by wrapping the VLOOKUP if an IFERROR function, with a structure like this:

=IFERROR(VLOOKUP(...),"OTHER")

 

[Dougmeister]

Thank you!

That's exactly what I was trying to remember and what I needed.

Thanks again!

 

[Joe4]

You are welcome.
Glad to help!