Extracting Data from Table to New Data Table

[x_ampl1]

Dear All

I have attachment workBook
IT has two sheets
1st: Data OT, this has all patients details
2nd: Laboratory results of HCG testing

At last Sheet (HCG) we adding the results of blood testing, according the received patient
for that we are writing the Patient file ID at column A
and blood result at Column B

---

---

What I need is to:

Transfer the result from table at HCG file to patient ID corresponding cell at Data OT sheet.

I did this equation
it gives part of data for only one ID:4165

but it missing some readings
and not working with other patients.

this my equation:

=IF(ROWS(E$5:E5)<=(SUMPRODUCT(--($A$5:$A$10000=A5),--($F$5:$F$10000=1))),INDEX(HCGResult,SMALL(IF(HCGfile=A5,ROW(HCGResult)-ROW(HCG!$B$2)+1),ROWS(E$5:E5))),"")

******** src="https://onedrive.live.com/embed?cid=FA4CA7F45EF7A5EC&resid=FA4CA7F45EF7A5EC%214831&authkey=AIJRSoVW-M66gvs&em=2" width="402" height="346" frameborder="0" scrolling="no">*********>

---

This My file link:
https://onedrive.live.com/redir?res...831&authkey=!AA4eXW2ArsvWH9E&ithint=file,xlsx


I need help to make it functional among all IDs at Whole table.

Thanks All

X_ampl1

 

[x_ampl1]

Dear All
can I find any support?

 

[x_ampl1]

Admin Please
can you check for me any help?