When you enter the postcode, I need the ward to automatically populate in the Ward Column next to it

[Leicester City Fox]

Hi There

I have a list of postcodes and their 16 wards. I want it sowhen someone enter the postcode into the postcode column it astronomically picksthe ward relating to this postcode and fill in next column once the postcodebeen entered.

Does anybody have any ideas how I could do this?

Many Thanks

Leicester City Fox.

 

[AlanY]

can try to use lookup table like this

Book1
	A	B	C	D	E
1	PostCode	Ward		AN12 3OT	Ward 1
2	AN12 6OT	Ward 1		AN12 4OT	Ward 1
3	AN13 4OT	Ward 2		AN12 5OT	Ward 1
4				AN12 6OT	Ward 1
5				AN12 7OT	Ward 1
6				AN13 3OT	Ward 2
7				AN13 4OT	Ward 2
Sheet1

Cell Formulas
Range	Formula
B2	=IFERROR(VLOOKUP(A2,$D:$E,2,FALSE),"")

 

[Leicester City Fox]

Hi Alan Y

I am very grateful the Formula worked a treat

You have a Great Day Now.

Many Thanks

The Leicester Fox

 

[AlanY]

you're welcome