Vlookup Help (2 columns)

Hi

I have the following situation

I have two columns with part codes (dont ask why two but the way the data is pulled down)

Part Code	Child Part code	Result
TPAA		Vlookup
TPBB		Vlookup

Below is the table to vlookup from

TPAA	5000
TPBB	2500

Below are the results

Part Code	Child Part code	Result
TPAA		5000
	TPBB	2500

Any help would be greatfully accepted

Thanks in advance

Patrick