Scripting Dictionary

[mole999]

I know these appear really fast, I have a worksheet that grows every day and currently 98% has to be looked up manually (basically a location, that then develops into postcode ad easting & northing plus A&B identifier's

In the table shown as A I am developing values in Col AN

I want to keep extending the lookups, and using those quickly fill Cols T to AI, overwriting with predefined values from the original work

can someone give me, vba to load T to AI into a dictionary

then a workable code that would look at AN, so the dictionary can be applied to the correct line.

I have 19 years of data over 35,000 lines, each success will reduce further the amount of time required to cross check and populate

Excel Workbook
	A	B	C	D	E	F	G	H	I	J
1	Master Streets			Returned Values
2	Col AN		T	U	V	W	Y	AG	AH	AI
3	PERRY STREET @ THAMES ROAD		A2000	PERRY STREET	A206	THAMES ROAD	DA1	54Hd 118	551707	176034
4	PENTONVILLE ROAD @ ISLINGTON HIGH STREET		A501	PENTONVILLE ROAD	A1	ISLINGTON HIGH STREET	N1	40Qb 70	531452	183143
5	THAMES ROAD @ PERRY STREET		A206	THAMES ROAD	A2000	PERRY STREET	DA1	54Hd 118	551707	176034
6	ACANTHUS DRIVE @			ACANTHUS DRIVE			SE1	50Wb 91	534214	178356
7	ACANTHUS DRIVE @ ROLLS ROAD			ACANTHUS DRIVE	B204	ROLLS ROAD	SE1	50Wb 91	534233	178325
8	ACANTHUS DRIVE @ ACHILLES CLOSE			ACANTHUS DRIVE		ACHILLES CLOSE	SE1	50Wb 91	534303	178340
9	ROLLS ROAD @ ACANTHUS DRIVE		B204	ROLLS ROAD		ACANTHUS DRIVE	SE1	50Wb 91	534233	178325
10	ACHILLES CLOSE @ ACANTHUS DRIVE			ACHILLES CLOSE		ACANTHUS DRIVE	SE1	50Wb 91	534303	178340
Sheet3