Comparing cell contents to lists

[tommy_sea]

Is it possible to create a formula which looks at the contents of a cell and compares it to several lists (also in Excel), then enters a value. I.e. I have a list of towns in column A. I want the region to be automatically inserted into column B. The towns are listed by region in a separate sheet.So I want Excel to look at A1 and compare the content to each of the regional lists and insert the correct region. Is this possible? I've tried a few things but I can't get anything to work.

Thanks,
tc

 

[sanrv1f]

Hi Tommy,

Welcome to the board,

have a look at VLOOKUP function,

http://www.contextures.com/xlFunctions02.html

 

[Domenic]

Can you post a small sample of the source data?