Excel data pull on duplicate IDs

%3CLINGO-SUB%20id%3D%22lingo-sub-3460070%22%20slang%3D%22en-US%22%3EExcel%20data%20pull%20on%20duplicate%20IDs%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3460070%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20build%20a%20tracker%20that%20show%20where%20my%20project%20is%20in%20the%20process%20(task%20%26amp%3B%20dates-%20created%2Fassigned%2Fready%20)%20the%20issue%20i%20am%20having%20is%20that%20my%20data%20dump%20file%20that%20shows%20the%20task%20status%20has%26nbsp%3Bduplicate%20job%20IDs%20and%20i%20cant%20use%20a%20vlookup%20i%20tried.%20i%20thought%20i%20had%20it%20working%20with%20a%20vlookup%20but%20when%20a%20resorted%20the%20data%20dump%20it%20didnt%20work%20anymore.%26nbsp%3B%20Here%20is%20what%20i%20am%20trying%20to%20do%20--%20lookup%20my%20job%20id%20on%20Main%20Tracker%20Search%20for%20it%20on%20the%20Data%20Dump%20tab%20-%20pull%20in%20the%20data%20to%20my%20tracker.%3C%2FP%3E%3CP%3E%3CEM%3EMain%20tracker%20-%20(showing%20only%20one%20task)i%20made%20up%20the%20data%20i%20am%20trying%20to%20pull%20in%20on%20the%20my%20tracker)%3C%2FEM%3E%3C%2FP%3E%3CTABLE%20width%3D%22874px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22112px%22%3ERequest%2FJob%3C%2FTD%3E%3CTD%20width%3D%2286px%22%3ESurvey%20Created%20Date%3C%2FTD%3E%3CTD%20width%3D%22119px%22%3ESurvey%20Status%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283px%22%3ESurvey%20Assigned%20Date%3C%2FTD%3E%3CTD%20width%3D%2283px%22%3ESurvey%20Accepted%20Date%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3ESurvey%20Ready%20for%20Approval%20Date%3C%2FTD%3E%3CTD%20width%3D%2285px%22%3ESurvey%20Approved%20Date%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3ESurvey%20Task%20Due%20Date%3C%2FTD%3E%3CTD%20width%3D%2286px%22%3ESurvey%20Scheduled%20Date%3C%2FTD%3E%3CTD%20width%3D%2263px%22%3ESurvey%20Status%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22112px%22%3EJB0000812941%3C%2FTD%3E%3CTD%20width%3D%2286px%22%3E9%2F5%2F1999%3C%2FTD%3E%3CTD%20width%3D%22119px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%2283px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2285px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2286px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2263px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22112px%22%3EJB0000967144%3C%2FTD%3E%3CTD%20width%3D%2286px%22%3E2%2F1%2F2021%3C%2FTD%3E%3CTD%20width%3D%22119px%22%3EApproved%3C%2FTD%3E%3CTD%20width%3D%2283px%22%3E4%2F15%2F2022%3C%2FTD%3E%3CTD%20width%3D%2283px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2285px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2286px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2263px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22112px%22%3EJB0000954107%3C%2FTD%3E%3CTD%20width%3D%2286px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22119px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2285px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2286px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2263px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22112px%22%3EJB0000855353%3C%2FTD%3E%3CTD%20width%3D%2286px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22119px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2283px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2282px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2285px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2275px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2286px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2263px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EData%20Dump%20File%3C%2FEM%3E%3C%2FP%3E%3CTABLE%20width%3D%221460px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%22112px%22%3ERequest%2FJob%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%22112px%22%3EJob%20Descr%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%22112px%22%3ETask%20Name2%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%22112px%22%3EJob%20Owner%20Name2%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%22112px%22%3EStatus%20Of%20Task%20Code%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%22112px%22%3ECreated%20Date2%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%22112px%22%3EAssigned%20Date2%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%22112px%22%3EAccepted%20Date2%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%22112px%22%3EReady%20for%20Approval%20Date2%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%22112px%22%3EApproved%20Date2%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%22112px%22%3ETask%20Due%20Date2%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%22112px%22%3EScheduled%20Date2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3EAddress%20Mismatch%20Validation%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E8%2F13%2F2020%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3ECapacity%20Verify%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E8%2F13%2F2020%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3ECoax%20Activation%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E8%2F13%2F2020%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E1%2F5%2F2022%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E1%2F28%2F2022%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E2%2F25%2F2022%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3ECoax%20Construction%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E8%2F13%2F2020%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3EDetermine%20Permits%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E8%2F13%2F2020%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3EEvaluate%20Constructed%20Items%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E2%2F16%2F2022%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3EEvaluate%20Estimates%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E2%2F16%2F2022%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3EFiber%20Activation%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E8%2F13%2F2020%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E1%2F5%2F2022%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E1%2F28%2F2022%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E2%2F25%2F2022%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3EFiber%20Construction%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E8%2F13%2F2020%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3EHeadend%20Design%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E8%2F13%2F2020%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3EHeadend%20Ready%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E8%2F13%2F2020%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3ESurvey%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E2%2F16%2F2022%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3EInstall%20Nodes%20COEPA%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E1%2F5%2F2022%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E1%2F5%2F2022%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E1%2F28%2F2022%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E2%2F25%2F2022%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3EJB0000426143%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3ECOEPA%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3EOptimize%20Nodes%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3ESD%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3ETask%20Not%20Required%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E8%2F13%2F2020%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E1%2F5%2F2022%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E2%2F25%2F2022%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%22139.875px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2294.8438px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22252.391px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22164.547px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22163.641px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2292.9219px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2274.25px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280.2188px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%22103.891px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2284.6406px%22%20height%3D%2230px%22%3E%26nbsp%3B%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3460070%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am trying to build a tracker that show where my project is in the process (task & dates- created/assigned/ready ) the issue i am having is that my data dump file that shows the task status has duplicate job IDs and i cant use a vlookup i tried. i thought i had it working with a vlookup but when a resorted the data dump it didnt work anymore.  Here is what i am trying to do -- lookup my job id on Main Tracker Search for it on the Data Dump tab - pull in the data to my tracker.

Main tracker - (showing only one task)i made up the data i am trying to pull in on the my tracker)

Request/JobSurvey Created DateSurvey Status Survey Assigned DateSurvey Accepted DateSurvey Ready for Approval DateSurvey Approved DateSurvey Task Due DateSurvey Scheduled DateSurvey Status
JB00008129419/5/1999Task Not Required       
JB00009671442/1/2021Approved4/15/2022      
JB0000954107         
JB0000855353         

 

 

Data Dump File

Request/JobJob DescrTask Name2Job Owner Name2Status Of Task CodeCreated Date2Assigned Date2Accepted Date2Ready for Approval Date2Approved Date2Task Due Date2Scheduled Date2
JB0000426143COEPAAddress Mismatch ValidationSDTask Not Required8/13/2020      
JB0000426143COEPACapacity VerifySDTask Not Required8/13/2020      
JB0000426143COEPACoax ActivationSDTask Not Required8/13/20201/5/20221/28/2022  2/25/2022 
JB0000426143COEPACoax ConstructionSDTask Not Required8/13/2020      
JB0000426143COEPADetermine PermitsSDTask Not Required8/13/2020      
JB0000426143COEPAEvaluate Constructed ItemsSDTask Not Required2/16/2022      
JB0000426143COEPAEvaluate EstimatesSDTask Not Required2/16/2022      
JB0000426143COEPAFiber ActivationSDTask Not Required8/13/20201/5/20221/28/2022  2/25/2022 
JB0000426143COEPAFiber ConstructionSDTask Not Required8/13/2020      
JB0000426143COEPAHeadend DesignSDTask Not Required8/13/2020      
JB0000426143COEPAHeadend ReadySDTask Not Required8/13/2020      
JB0000426143COEPASurveySDTask Not Required2/16/2022      
JB0000426143COEPAInstall Nodes COEPASDTask Not Required1/5/20221/5/20221/28/2022  2/25/2022 
JB0000426143COEPAOptimize NodesSDTask Not Required8/13/20201/5/2022   2/25/2022 
            
0 Replies