As stated in the OP:

Firstly, I am attempting to make a count of visitors to a site by postcode/ward. At the moment, I have Sheet 1 column A to enter postcode. I have on another sheet (same workbook) 3 coloums of all the postcodes within the 3 wards I want to check against. In sheet 1, I have added a column B using drop down boxes to manually choose the ward after searching for the postcode in sheet 2 and noting which column this falls under.

Now, this is fine for new entries, but I have over 600 unique visitors already on the worksheet.

Is there a way to get column B to auto check against sheet 2 and auto-enter the ward based on which column the postcode is found under on sheet 2?

So, something that would like;



User manually enters postcode in sheet 1 cell A1
If postcode entered matches entry in sheet2 column A, enter "ward A" in sheet1 cell B1
If postcode entered matches entry in sheet2 column B, enter "ward B" in sheet 1 cell B1
If postcode entered matches entry in sheet2 column C, enter "ward C" in sheet 1 cell B1
If postcode entered does NOT match any entry in sheet2, enter "other" in sheet 1 cell B1

And so on from sheet1 cell A1 down to A600 and beyond for new entries.

I attached a sample in the second post.

Thanks

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