Can anyone help with this problem? The Col L is where I have inserted the formula to arrive at my answer. However, because R1 in Col E is found in Dual Carriageway (Nominated) and One Way Single Carriageway (in Col M) the answer is skewed.
How do I adjust the formula in Col L so that if R1=Dual Carriageway then it arrives at the answer as "CR", whereas if R1=One Way Single Carriageway, then the answer is "OFF Verge".
Any help would be much appreciated.
Cheers
Matt
Bookmarks