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)
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)
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks