Spreadsheet: 274006d1382980435-combine-2-worksheets-and-do-multiple-column-vlookups-ex_combine-and-vlookup-multiple-columns
Sheet: VLookup

PR ID | Vlookup from Column F | Vlookup from Column G | AR - Device Problem Code 4 | PR ID | Event Description | Country of Event | Age at Time of Event | Gender | If Reportable, Type | Date Closed | Assigned To | Awareness Date | Divisional Account Number | Initial Reporter Facility | Product Long Description | As Reported Product Details | Lot/Serial No. | Manufacturing Date | Brand | Product Available | CMC | PAC | Physician Name | Catalog # | PI ID | Initial Reporter Name
262888 |  |  | NV - Catheter hub friction | 262888 | The case was pulmonary arteriovenous fistula. Renegade18 was used for artery embolization. 	 [NAME] was delivered to the target region, and the other company's pushable coil was attempted to be inserted into Renegade18. However, the coil was stuck at the hub. Renegade18 was removed and replaced with the new one.	Flush was intermittent.		Additional information: Resistance was encountered when the coil was being inserted into the microcatheter hub, but then became stuck in the hub and both the microcatheter and coil were removed and replaced. | Japan |  | Unknown | No Report Required |  | [NAME] | 41516 |  | Tokyo | RENEGADE |  | 1253466 | 41074 | [NAME] | No | Trama | Intl | Dr. |  | 262887 | [NAME]
262888 |  |  | NV - Catheter, coil jammed | 262893 | After placing of the Guiding catheter in the patient body, the operator wanted to use the Synchro Guidewire to guide the Enchelon Microtheter, But during the procedure, the operator felt the Synchro Guidewire was too rough and it was difficult to guide the catheter to the lesion. Then he changed to another same synchro guidewire, it was smooth and easy to guide the catheter to the lesion. The case was completed successfully.		Update received 22-Sep-2013:	Please clarify if “roughness” was meant to describe issues with the Synchro’s coating? no	OR the “roughness” was meant to describe resistance during advancement of the Synchro through the catheter? yes	Was the “roughness” issue noted at the distal end section of the Synchro? yes | China |  |  | No Report Required |  | [NAME] | 41518 |  |  | SYNCHRO | XX3945855 | 546213 |  | Synchro | Return | Trama | Intl | Dr. | XX3945855 | 262892 | [NAME]
262893 |  |  | NV - Catheter has difficulty tracking over guidewire | 262896 | The case was  in Stand process. The operator used a transend guide wire to guide the Excelsior SL-10 micro catheter’s tip to the lesion, and exchange the guide wire with transcend Floppy 300. Dilation with two Gateway of 2.0*9 and 2.5mm successfully, prepare the [NAME] stent. It’s fine with the package of the stent, and the operator used the Sterile heparinization saline solution to flush the dispense hoop, Carefully pull out the proximal hub assemblies from tray, tighten then rotating hemostasis valve onto the Inner Body and remove the delivery System. Inspect it, no  damage. The inner and external catheter were be flushed. The stent was advanced to the lesion slowly and no abnormal phenomena occurred. Loosen the rotating hemostasis valve (RHV) on the Delivery System Outer Body and pushed the forth mark to the distal mark of the stent, tighten the the hemostasis valve (RHV) on the Delivery System Outer Body , positioned the stent with the lesion. Loosen the hemostasis valve (RHV) on the Delivery System Outer Body , used one hand to keep the inner stable catheter, the other hand  to pull the external catheter of the stent .The operator found that the external catheter of the stent can’t be pulled, and failed to deployed it .The case was terminated because of  no same size stent, and the patient was hemiplegic. | China | 46 | F | Immediate but not longer than 10/30 Days |  | [NAME] | 41518 |  |  | [NAME] | 4928458965 | 1125255 | 40878 | [NAME] | Return | Trama | Intl | Dr. | 4928458965 | 262895 | [NAME]
262896 |  |  | NV - Stent delivery catheter friction | 262904 | When the guide wire was removed from the dispenser hoop after the preparation as per DFU, it was noted that 30cm portion from the proximal of the guide wire has been bent. The guide wire was replaced with the new one. | Japan |  | M | No Report Required |  | Mark | 41519 |  | Kanai | TRANSEND |  | 12214551 |  | Transend | Return | Trama | Intl | Dr. |  | 262903 | [NAME]
262896 |  |  | NV - Stent failed/unable to deploy | 262918 | The case was unruptured basilar tip aneurysm embolization. NeuroformEZ and Enterprise were used, and 23 coils(1 GDC coil and 22 non-Stryker's coil) were implanted. After the procedure, cerebral infarction was confirmed. No additional treatment for the cerebral infarction was performed.	In the physician's opinion, the causal relationship with NeuroformEZ is unknown but he considers that the adverse consequence relates with the procedure.	Past medical history : Left ruptured MCA aneurysm was clipped in March 2013.		pre operation mRS: Unknown(Not performed)	post operation mRS: Grade4	30days after [NAME]: Grade4		[NAME]'s condition : Remission		Additional information: The patient underwent successful stent assisted embolization of the unruptured basilar tip aneurysm. Post procedure, imaging showed thalamus, corpus callosum and cerebellum stroke complicated by hydrocephalus. The patient suffered clouding of consciousness. The reported cerebral infarction was not treated; however, hydrocephalus was treated. Treatment of hydrocephalus is unknown. The patient condition was reportedly improved. The patient can walk by using handrail but “clouding of consciousness hasn't fully resolved.” The physician stated that the causal relationship to the subject device is unknown but the adverse consequence related to the procedure. <EN18SEP2013>		Additional information: Cerebral shunt was placed to treat hydrocephalus. <EN19SEP2013> | Japan | 64 | F | Immediate but not longer than 10/30 Days |  | [NAME] | 41519 |  | Sapporo | Neuroform |  | 15412552 | 41024 | Neuroform EZ | No | Trama | Intl | Dr. |  | 262909 | [NAME]
262896 |  |  | NV - Patient Complications | 263158 | When the coil was inserted into the microcatheter(Prograte /TERUMO), resistance was felt but the physician continued advancing the coil. The delivery wire was bent during advancement. The coil was removed and replaced with the new one.		Additional information:  Progreteβ ID: 0.021inch microcatheter was used for the procedure. Three coils were introduced through this catheter prior to the subject coil and the microcatheter used for the whole procedure. Resistance was encountered when advancing the subject coil through the microcatheter in the mid portion of the microcatheter. The delivery wire was bent at 60cm from the proximal end. <EN18SEP2013> | Japan |  | M | No Report Required | 41542.66666666666 | [NAME] | 41519 |  | Tokyo | GDC |  | 4582126 | 41028 | GDC | No | Trama | Intl | Dr. |  | 263129 | [NAME]
262904 |  |  | NV - Guidewire proximal section kinked/bent | 263161 | The case was CCF. 	When 14th coil was attempted to be detach by using the complaint InZone, the system ready indicator didn't light on. 13 coils were able to be detached without the problem by the complaint InZone before the event. The Inzone was replaced with the new one.		The complaint coil was used as a 17th coil. When the physician attempted to detach the coil, he found the proximal contact had been bent. He removed the coil and replaced it with the new one. | Japan |  | M | No Report Required |  | [NAME] | 41519 |  | Kanai | InZone |  | 55462146 |  | InZone | Return | Trama | Intl | Dr. |  | 263159 | [NAME]
262918 |  |  | NV - Patient Stroke | 263162 | The case was CCF. 	When 14th coil was attempted to be detach by using the complaint InZone, the system ready indicator didn't light on. 13 coils were able to be detached without the problem by the complaint InZone before the event. The Inzone was replaced with the new one.		The complaint coil was used as a 17th coil. When the physician attempted to detach the coil, he found the proximal contact had been bent. He removed the coil and replaced it with the new one. | Japan |  | M | No Report Required |  | Mark | 41519 |  | Osaka | Target |  | 14965485 |  | TARGET | Return | Trama | Intl | Dr. |  | 263159 | [NAME]
262918 |  |  | NV - Patient Complications | 263186 | The coils were used for TVE of dural AVF. [NAME] flush was maintained.	[Target 360 Soft 7*30]	When the coil was inserted into the microcatheter after the preparation, the bend of the proximal contact was found. The coil was replaced with the new one. There were no anomalies noted to the coil prior to use.		[Target 360 Soft 8*30]	When the coil was advanced into the microcatheter after the preparation, resistance was felt at 30cm portion from the hub. Although the coil was retracted into the introducer sheath and it was tried to be reinsert, the coil was removed because the resistance was increased. There were no anomalies noted to the coil prior to use. | Japan |  | M | No Report Required | 41523.64722222222 | Mark | 41519 |  | Osaka | Target |  | 452241565 |  | TARGET | No | Trama | Intl | Dr. |  | 263163 | [NAME]
263158 |  |  | NV - Coil in catheter friction | 263187 | The coils were used for TVE of dural AVF. [NAME] flush was maintained.	[Target 360 Soft 7*30]	When the coil was inserted into the microcatheter after the preparation, the bend of the proximal contact was found. The coil was replaced with the new one. There were no anomalies noted to the coil prior to use.		[Target 360 Soft 8*30]	When the coil was advanced into the microcatheter after the preparation, resistance was felt at 30cm portion from the hub. Although the coil was retracted into the introducer sheath and it was tried to be reinsert, the coil was removed because the resistance was increased. There were no anomalies noted to the coil prior to use. | Japan |  | M | No Report Required |  | Mark | 41519 |  | Sapporo | Target |  | 421552115 | 41262 | TARGET | No | Trama | Intl | Dr. |  | 263163 | [NAME]
263158 |  |  | NV - Coil delivery wire kinked/bent | 263189 | The operator used transcend floppy 0.014*300 to guide the Gateway Balloon to the lesion  in tortuous path . After dilation, exchange the balloon with the [NAME] system. The stent system was flushed under instruction, and arrived at the lesion easily. But it couldn’t be deployment. The operator tried for many times, failed at last. So the operator wanted to pulled out the stent and use another guidewire to strength the support, when he pulled out the stent and check the stent system, found the stent had been partially deployed and couldn’t be used again. | China |  |  | Immediate but not longer than 30 Days |  | [NAME] | 41519 |  |  | [NAME] | 4928458965 | 415122115 | 41186 | [NAME] | Return | Trama | Intl | Dr. | 4928458965 | 263188 | [NAME]
263161 |  |  | NV - Power supply does not power on after sleep mode | 263192 | The patient’s BA is very tortuous, and the wingspan stent of 4.5*20 couldn’t be deployed, during  the retracement of the stent, it was deployed in the Rotating Hemostatic Valve, at last the operator completed the case with a Enterprise stent of 4.5*22. 		Additional information states resistance was felt advancing the stent system. | China |  |  | Immediate but not longer than 30 Days |  | [NAME] | 41519 |  |  | [NAME] | 4928458966 | 515123464 | 40941 | [NAME] | Return | Trama | Intl | Dr. | 4928458966 | 263191 | [NAME]
263162 |  |  | NV - Coil proximal contact kinked/bent | 263196 | The operator advanced the [NAME] stent system to the lesion under standard process, but failed to deploy it. So pulled it out and changed with another same size [NAME] system , deployed it successfully , and the patient was fine. | China |  |  | No Report Required |  | [NAME] | 41519 |  |  | [NAME] | 4928458967 | 8694231689 |  | [NAME] | Return | Trama | Intl | Dr. | 4928458967 | 263194 | [NAME]
263186 |  |  | NV - Coil proximal contact kinked/bent | 263200 | The operator confirmed that the stenosis lesion at the bifurcation of ICA under radiography, then advanced the Guiding catheter. The operator  guided the microcatheter to the MCA at the right side with Synchro 300 cm, the path  was  tortuous. Dilated  the lesion with the Balloon of 2.5*9mm, then selected the [NAME] stent of 3.5*15, tightened the Y valve, advanced the stent system to the Y valve of Guiding Catheter through the 300cm guidewire, the operator found that the distal tip of stent drop out of system, so the operator pulled out the stent system and tried to get the stent tip into system , pulled the stable catheter for many times, but failed. And the stent was deployed out of body. At last deployed another [NAME] of 3.5*15mm at the stenosis lesion successfully.		Additional information: The physician felt some resistance when pulled the sent system through Y valve。The physician repositioned the system twice. It was confirmed that the stent partially deployed when it was being advanced though Y valve due to the inner body was advanced independently of the entire system. After “the stent drop out of system”, the physician removed the whole stent delivery system; “tried to get the stent tip into system” using the inner body but the stent deployed outside. The stent delivery system was never been advanced inside the patient. There was no patient involvement. <EN12SEP2013> | China |  |  | No Report Required |  | [NAME] | 41520 |  |  | [NAME] | 4928458968 | 4846461434 |  | [NAME] | Return | Trama | Intl | Dr. | 4928458968 | 263199 | [NAME]
263187 |  |  | NV - Coil in catheter friction
263189 |  |  | NV - Stent partial deployment
263189 |  |  | NV - Stent failed/unable to deploy
263192 |  |  | NV - Stent failed/unable to deploy
263192 |  |  | NV - Stent deployed prematurely during use
263192 |  |  | NV - Stent delivery catheter friction
263196 |  |  | NV - Stent failed/unable to deploy
263200 |  |  | NV - Stent deployed prematurely during preparation
263205 |  |  | NV - Stent failed/unable to deploy
263205 |  |  | NV - Stent deployed prematurely during use
263207 |  |  | NV - Stent failed/unable to deploy
263218 |  |  | NV - Guidewire distal tip kinked/bent
263339 |  |  | NV - Stent stabilizer kinked/bent
263339 |  |  | NV - Stent stabilizer/guidewire friction
264064 |  |  | NV - Patient Stroke
264064 |  |  | NV - Patient Thrombosis(treated vessel)
264216 |  |  | NV - Coil introducer sheath kinked/bent
264298 |  |  | NV - Embolus
265224 |  |  | NV - Main coil difficulty inserting
265224 |  |  | NV - Coil introducer sheath friction
265317 |  |  | NV - Device foreign matter
265675 |  |  | NV - Main coil protrusion
265675 |  |  | NV - Coil broken/fractured
265675 |  |  | NV - Device interaction with another device
266260 |  |  | NV - Guidewire distal tip detached/separated
266313 |  |  | NV - Device problem unknown/unclear
266376 |  |  | NV - Catheter hub broken/fractured
266378 |  |  | NV - Coil in catheter friction
266877 |  |  | NV - Coil in catheter friction
266879 |  |  | NV - Patient Hemorrhage, Blood Loss with Sequelae
266880 |  |  | NV - Patient Hemorrhage, Blood Loss with Sequelae
266881 |  |  | NV - Patient Hemorrhage, Blood Loss with Sequelae
267149 |  |  | NV - Coil in catheter friction
267511 |  |  | NV - Patient Thrombosis(treated vessel)
267511 |  |  | NV - Patient Death
267694 |  |  | NV - Main coil failed/unable to detach
267694 |  |  | NV - Device interaction with another device
267801 |  |  | NV - Main coil stretched
267801 |  |  | NV - Main coil friction
267804 |  |  | NV - Balloon RO marker band not visible under fluoroscopy