![[RB]](/styles/overclockers/avatars/4.png){kind=avatar}
Hi All,
I have a list of addresses in columns, I'd like to create a function that will check through these and compare them to a list of Post Codes that fall within the M25 and give the result Y or N if the address is or isn't inside the M25.
This is where I've got to so far:
With X being the post code string I'm searching for and Y being the cell being searched
Now this works if I enter specific values in XXX or refer to a single cell, but I don't seem to be able to enter a range in there. If I do the results are always "N"
Is there a way of modifying the above to take into account ranges?
Many thanks for any help.
RB.
I have a list of addresses in columns, I'd like to create a function that will check through these and compare them to a list of Post Codes that fall within the M25 and give the result Y or N if the address is or isn't inside the M25.
This is where I've got to so far:
Code:
=IF(ISNUMBER(FIND(XXX,YYY)),"Y", "N")With X being the post code string I'm searching for and Y being the cell being searched
Now this works if I enter specific values in XXX or refer to a single cell, but I don't seem to be able to enter a range in there. If I do the results are always "N"
Is there a way of modifying the above to take into account ranges?
Many thanks for any help.
RB.