formula to input city and output area code

[brennagcollins]

I have a list of area codes and match up with cities listed as such:

column K: area codes
column L: cities
column C: where im entering the city manually for each client


What I am wonder is how to type a city into column C and have it sift through my areacode/city table and output the area code that matches into a new column.

I have tried lookup formulas (=LOOKUP(C:C,L:L,K:K) and it just isnt working exactly how i need it to as it isnt matching the city properly.

 

[Momentman]

Here i assumed you are looking for the area code of the City you have typed in C1

use =INDEX($K:$L,MATCH(C1,$L:$L,0),1) wherever you want the area code returned

 

[brennagcollins]

yes! Worked perfectly! Thank you!