View Single Post
 
Old 11-13-2014, 03:49 AM
JaxV JaxV is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Nov 2014
Posts: 8
JaxV is on a distinguished road
Default

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
Reply With Quote