Formula for a spreadsheet idea

Hi guys,

At work we have a layout of stations in multiple areas. For example, Area 1, 2, 3, 4, and 5. In these areas we have the station name, ie station 1 and it has an "ID number" for example, 81. In this there is upwards of 100 stations, and in another area there may be 20. Each have different ID numbers.

I want to make a spreadsheet/excel document that when the station name is entered, it will feedback the location (area 1,2,3,4,5) and also the ID number in separate columns. To the side I have listed the station names and their ID numbers but I cannot find a formula that will make this idea work.

So far, I can feedback the location of the station, but not the ID number. The current formula is; =IF(AND(A2>=$M$3, A2<=$M$82),"Area 1", "") I have attached an image (below) or what I have managed to get.

http://i.imgur.com/VH1IPay.jpg - ID (DHL) Number should not be the name of the host, it should be the corresponding one.

If anyone call help in any way, I would appreciate it! Hopefully it is straight forward!

Kind regards,
Dan.

Hi,

I have attached the spreadsheet to this.