Still looking for help on the postcode look up, ive tried various lookup and if formulas but still a bit of a noob :/
This is what I want the formula to achieve:
Postcode is entered manually in 5C.
5D contains formula to check postcode against postcodes! columns A, B and C.
If postcode is found in column A, fill 5D with text "Ward1"
If postcode is found in column B, fill 5D with text "Ward2"
If postcode is found in column C, fill 5D with text "Ward3"
If postcode is not found, fill 5D with text "Other"
This formula would need to be copied down for 600+ rows so cant have the $ thingies.
Please someone help? This is the last piece in the puzzle for a very important worksheet for our funding