Excel 2007 : Lookup:all area codes

**hdlqepm** · 12-16-2009, 06:14 PM

I am wondering if it is possible to achieve the following. I currently have all area codes with states and time zones in an excel spreadsheet. my goal is to create a type of locked look up form where i can enter an area code and have it return the state and time zone. I want to lock it down to where the only viewable cells would be the Query cell as well as the result cells. Any ideas or tips? I have not used excel very much and have looked online for help to no avail. any and all help would be appreciated!

**teylyn** · 12-16-2009, 06:21 PM

Hi hdlqepm,

welcome to the forum.

You're probably after a VLOOKUP formula. If your list of zip codes is in Sheet2, starting with a row of headers, area code in column A, state in column B and time zone in column C, then you could

- enter the area code in Sheet1 cell A1
- in B1 on sheet1 put this formula to return the state

=vlookup(a1,Sheet2!$a$2:$c$1000,2,false)

to look up the time zone, put this formula into C1

=vlookup(a1,Sheet2!$a$2:$c$1000,3,false)

Hope that helps