Sorting Area Codes into time zones

**3dw4rd3** · 07-01-2013, 12:40 PM

I am trying to sort area codes into time zones please help!

I have 10 digit #'s (11 counting the 1+2135551212) in column A. I need to sort using the area codes that are already on sheet2 and sorted into their respective time zones. Can I do this with VLOOOKUP?

Thanks

**alansidman** · 07-01-2013, 12:43 PM

Suggest you post a copy of your workbook so that we can see the layout and provide a specific response.

**3dw4rd3** · 07-01-2013, 01:28 PM

Please see the attached file ...

**alansidman** · 07-01-2013, 02:17 PM

Look at the attached. I rearranged your sheet2 to allow for a vlookup. The formula to do the lookup is

=VLOOKUP(MID(D1,3,3),Sheet2!$G$1:$H$314,2,FALSE)

**3dw4rd3** · 07-01-2013, 03:16 PM

Alan,

Thank you for the response, can you tell me what you did to the format. I am not getting any results. After loading data into sheet 1? Are you just adding the formula in the F column? The result is "Eastern" only. Can you help me understand?

**alansidman** · 07-01-2013, 04:54 PM

Changed the format of the Sheet2 to two columns. first column has area code without comma and second column has time zone. On sheet1, I created the formula shown in thread above and copied down. No other changes made to sheet1. Be sure your formula has the correct references to sheet2.

Suggest you reload your modified spreadsheet for analysis of the issues.