Using if with a list

[Believe82]

I am looking for places to live and giving them values based on some conditions (helps me think) and everything is working fine but here is where I needed to simplify, I want the formula to add 200000 whenever a tube stop is displayed.

I have a column where I have the tube stops of each place, on column "M"

This my formula at the moment:

=IF(OR(M6="Canary Wharf";M6="South Quay";M6="Haron Quays";M6="Poplar";M6="All saints";M6="Crossharbour";M6="Mudchutte";M6="Island Gardens");200000;0)

The thing is I wanted to simplify this formula in a way that I create a list, on another sheet with the tube stops i want it to sum 200000 because I am afraid I get to a point I have to many stops and the formula is to big. Is there a way to create a formula that it would go and look if the value is on my list and put 200000?

[Kevin UK]

Hi Believe82

What if you put your tube stops in a cells S1:S8
Canary Wharf
South Quay
Haron Quays
Poplar
All saints
Crossharbour
Mudchutte
Island Gardens

Then: =IFERROR(IF(MATCH(M6,S1:S8,0)>0,200000),0)

[newdoverman]

One way of doing this is to create a list of all the tube stations (which I did in T1:T8) and use this formula:

Please Login or Register  to view this content.

If there is a tube station in M6 that is in the tube station list, 20,000 will be returned. If not, a 0 will be returned.

[Believe82]

Thank you both for the quick reply! Worked like a charm!