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

NEW Cust ID	Account_Customer	OLD Account_No
111	No	A53821
112	Yes	A53822
113	No	AAC00001
114	Yes	ABB00001
115	No	ACC00001
116	Yes	ADD00001
117	Yes	ADI00001
118	No	ADL00001

<colgroup><col width="152" style="width:114pt"> <col width="152" style="width:114pt"> <col width="152" style="width:114pt"> </colgroup><tbody>
</tbody>

Sheet 2

NEW Cust ID	OLD Account_No
	A53822
	000537
	ATF00001
	AAC00001
	ABB00001
	ABB00001
	ABB00001
	ACC00001
	ADD00001

<tbody>
</tbody>

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