OK, I've got a spreadsheet with students from all 50 states.
What i'm trying to do is write a macro or a function that checks cell "I" of Table name "ADU" and fills in the state based of a table or code, if that makes sense??
In my Example below, it would lookup the student in row 2, check column I, see the field is BRONX, and would therefore fill in column J with New York.
Anyone know how i could accomplish this? I have to repeat this each month, and doing it all by hand seems...uh.. tedious for 10K plus students.
(Example)
What i'm trying to do is write a macro or a function that checks cell "I" of Table name "ADU" and fills in the state based of a table or code, if that makes sense??
In my Example below, it would lookup the student in row 2, check column I, see the field is BRONX, and would therefore fill in column J with New York.
Anyone know how i could accomplish this? I have to repeat this each month, and doing it all by hand seems...uh.. tedious for 10K plus students.
(Example)
A | B | C | D | E | F | G | H | I | J | |
---|---|---|---|---|---|---|---|---|---|---|
1 | DISPLAYNAME | SURNAME | FIRSTNAME | MI | GEN | STUID | CODE | ROLE | City | STATE |
2 | DOE.JOHN.C | DOE | JOHN | C | 1234567890 | A | STU | BRONX |