Hi,
I have a spreachsheet that contains postcode data.
Some of my formulas are:
:
In cell C2 =IF(A2="","",OR(I2="CITY",B2="YES"))
In cell D2 =IF(C2=TRUE,"YES","NO")
In cell I2 =IF($A2="","",INDEX(DISTRICT,MATCH(Sheet2!A2,POSTCODES,0)))
I would like the formula in C2 if possible to display directly Yes or No and not True or false so I can delete column D.
The problem that I seem to have is in cell C2 the or function doesnt work as the value in cell I2 contains a formula and doen't match to my (I2=City). If I type manually in cell I2 the formula and type "City" then the formula correspond.
Another issue that I have is that In column D once I paste down the formula I would like to leave it blank and not display the value "No" as the cells in column A are blank.
Another question that I would like to ask is why my file is approx 3MB while it only contains a small amount of data?
I have attached a copy of my spreadsheet. If you need any additional info please let me know.
Many thanks
Bookmarks