macro or formula to read col, put value in another

[flashbbeb]

Hello,

I'm mapping from a report low level business areas (200+) to high level business areas (13). The report only gives me the low level business areas (high level cannot be included due to system limitations). We have manually mapped these for one report, but next week we'll have to do the same thing over again...

Example:
HIGH LEVEL LOW LEVEL
Information Systems Application Development
Information Systems Web/Graphics
Accounting Accts Payable
Accounting Accounts Receivable
Accounting Payroll Processing
Admin Services Graphics and Marketing
Human Resources Training
Human Resources Recruiting

I have the lists of the 200 mapped to the 13, but I want the high level field to auto-populate based on the low level area.

Can any one assist?

Thanks!
EB

 

[flashbbeb]

Figured out vlookup myself!

=vlookup(the cell I'm looking at,a table that lists values side-by-side-could be a name or range, which column I'm looking at in the side-by-side table, whether it isn't an exact match - false is exact)


=VLOOKUP(A10,verticalmap!$A:$B,2,FALSE)