Bring row data consists of finding random number

[Osama Fawzy]

HI, I have four table at four sheets consists of the following:
table #1

A/C	Description	P/N Installed	Serial-Number	Position	TLB	Date

table #2

Part-Number	Serial-Number
3-1531-3	A9195​
3-1531-3	9424​
3-1531-3	A9197​
3-1531-3	5426​
3-1531-3	A6656​
3-1531-3	6905​
	​

table #3

Description	P/N Installed	Serial-Number	Date	T.L.B	A/C TH
NOSE WHEEL #1	3-1531-3	A9195	21-Aug-22	000249	30642:29
NOSE WHEEL #1	3-1531-3	A6241	22-Aug-22	000252	30652:24
NOSE WHEEL #2	3-1531-3	6905	22-Aug-22	000252	30652:24

table #4

P/N Removed	Removed	P/N Installed	Serial-Number	Date	T.L.B	A/C TH	A/C TC
C12850BC03	C12850007512	C1285BC03	C12850008633	25-Aug-22	000209	30621:15	12843
C20195162	45253	C20195162	5426	3-Sep-22	000263	30724:30	12895
C12850BC03	C12850008633	C1285BC03	C12850008920	5-Sep-22	000272	30742:42	12904

I want to search at tables (#3 & #4) at column (Serial-Number) consists of the numbers at the same column at table #2 and bring row data from table #3 or #4 to table #1 , for example serial number (A9195) is the same number at tables (2 & 3), i want to bring this number and it's row data at table #1, the number (5426) is the same number at tables (2&4) i want to bring this number and it's row data at table #1

 

[Legacy 143009]

Neither Table2 nor Table 4 does not include a Description column for 5426. What to write to Description column on Table1?

 

[Osama Fawzy]

Neither Table2 nor Table 4 does not include a Description column for 5426. What to write to Description column on Table1?

Thanks for you, the Description column include at table 4 but i forgot copy it, if you want consider all tables are the same columns

 

[Legacy 143009]

Assuming serial numbers are found on Tabşe2 Column D. Paste the formula to Table1 A2.
It should work if I got it correctly.

=IFERROR(INDEX('Table3'!$A:$H,MATCH('Table2'!$D2,'Table3'!$A:$H,0),MATCH('Table1'!A$1,'Table3'!$A:$H,0)),INDEX('Table4'!$A:$H,MATCH('Table2'!$D2,'Table4'!$A:$H,0),MATCH('Table1'!A$1,'Table4'!$A:$H,0)))

 

[Osama Fawzy]

Assuming serial numbers are found on Tabşe2 Column D. Paste the formula to Table1 A2.
It should work if I got it correctly.

=IFERROR(INDEX('Table3'!$A:$H,MATCH('Table2'!$D2,'Table3'!$A:$H,0),MATCH('Table1'!A$1,'Table3'!$A:$H,0)),INDEX('Table4'!$A:$H,MATCH('Table2'!$D2,'Table4'!$A:$H,0),MATCH('Table1'!A$1,'Table4'!$A:$H,0)))

Thanks a lot, but the formula not working properly , I want if any number at table #2 (S/N Installed) found at the same name column at table #3 or table #4 put cells under (Description, P/N Installed, S/N Installed & TLB) from table #3 or table #4 under the same title cells at table #1

 

[Legacy 143009]

Could you please share a sample worksheet?

 

[Osama Fawzy]

Could you please share a sample worksheet?

Thank u, please see the first message, at a table #1 I want to bring data (Serial Numbers) where its written randomly and a lot, from table #3 and table #4 based on table #2 column (Serial Number), where its standard