Assigning Values

Hi.

The situation I'm having is this:

In column A, I have 24,000 miscellaneous [and repeating] zip codes, which need to be translated to their appropriate state. In column B I have all the zip codes [3267 in total], and in column C I have the various states which correspond to the zip codes in column B.[ For example, b2 [91360] = c2 [CA] ] Is there any way I can use the information in columns B and C, and 'assign' the appropriate state in column A?

Hoping you can help, otherwise I'm in for a looong night.

Thanks.

Hi

The following code needs to be added to a VBA module, Hit Alt+F11 to go to the VBA Editor and in the project explorer pane right click and select "Insert Module".

Please Login or Register  to view this content.

The code will replace the zipcode with the state, or substitute another column number to keep the zipcode and add the state.

Regards

Jeff