Pull through ID data to other sheets

[jpwg19]

Hi all
I have a load of data that I need to upload to a new system using a new customer account number, and with only basic levels of knowledge in excel I was hoping that someone may be able to help or point me in the right direction to research how to do it.


The data is split into a large number of sheets with the only unique field in each sheet being the old account number and the new account number only showing on the first sheet. I need to pull the new account number over to all the other sheets but there maybe more than one line of the same account number on sheet 2, sheet 3 etc due to multiple properties for that one customers account number. It could also be the case that there is no data on Sheet 2, Sheet 3 etc for the Sheet 1 Account Number due to data deletion.

Sheet 1
[TABLE="width: 456"]
<colgroup><col width="152" style="width:114pt"> <col width="152" style="width:114pt"> <col width="152" style="width:114pt"> </colgroup><tbody>[TR]
[TD="class: xl69, width: 152"]NEW Cust ID[/TD]
[TD="class: xl65, width: 152"]Account_Customer[/TD]
[TD="class: xl65, width: 152"]OLD Account_No[/TD]
[/TR]
[TR]
[TD="class: xl69"]111[/TD]
[TD="class: xl67"]No[/TD]
[TD="class: xl66"]A53821[/TD]
[/TR]
[TR]
[TD="class: xl69"]112[/TD]
[TD="class: xl67"]Yes[/TD]
[TD="class: xl66"]A53822[/TD]
[/TR]
[TR]
[TD="class: xl69"]113[/TD]
[TD="class: xl67"]No[/TD]
[TD="class: xl66"]AAC00001[/TD]
[/TR]
[TR]
[TD="class: xl69"]114[/TD]
[TD="class: xl67"]Yes[/TD]
[TD="class: xl66"]ABB00001[/TD]
[/TR]
[TR]
[TD="class: xl69"]115[/TD]
[TD="class: xl67"]No[/TD]
[TD="class: xl66"]ACC00001[/TD]
[/TR]
[TR]
[TD="class: xl69"]116[/TD]
[TD="class: xl67"]Yes[/TD]
[TD="class: xl66"]ADD00001[/TD]
[/TR]
[TR]
[TD="class: xl69"]117[/TD]
[TD="class: xl67"]Yes[/TD]
[TD="class: xl66"]ADI00001[/TD]
[/TR]
[TR]
[TD="class: xl69"]118[/TD]
[TD="class: xl67"]No[/TD]
[TD="class: xl66"]ADL00001[/TD]
[/TR]
</tbody>[/TABLE]

Sheet 2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]NEW Cust ID[/TD]
[TD]OLD Account_No[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]A53822[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]000537[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ATF00001[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AAC00001[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ABB00001[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ABB00001[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ABB00001[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ACC00001[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]ADD00001[/TD]
[/TR]
</tbody>[/TABLE]

Many thanks

 

[Fluff]

How about

Excel 2013/2016
	A	B
1	NEW Cust ID	OLD Account_No
2	112	A53822
3	Noaccount	537
4	Noaccount	ATF00001
5	113	AAC00001
6	114	ABB00001
7	114	ABB00001
8	114	ABB00001
9	115	ACC00001
10	116	ADD00001
sheet2

Cell Formulas
Range	Formula
A2	=IFERROR(INDEX(Sheet1!A$2:C$9,MATCH(B2,Sheet1!C$2:C$9,0),1),"Noaccount")

 

[jpwg19]

Thanks very much, tweaked it a bit as I have more lines but works a treat, thank you.

 

[Fluff]

Glad to help & thanks for the feedback