Best way to get data from other cell

[eechristaylor]

I have data where I am trying to link a part number to a task so that I can populate the qty for the part number. The below is the data and how the material should relate to the labor. Any thoughts/suggestions/solutions would be greatly appreciated.

Task #	Code/Part #	Task#-Code	Labor/Material	Description	Qty
542​	415​	542-415	Labor	Pull Cable in Duct (up to two cables)	508​
542​	416​	542-416	Labor	Pull Cable in Duct - Adder per cable over 2 (3, 4, --...)
542​	500​	542-500	Labor	Install ADSS Fiber (per Sheath Ft )	26,174​
542​	503​	542-503	Labor	Install Aerial Storage Loop (Pole Mount Storage Bracket + U-guard)
542​	504​	542-504	Labor	Install Riser/U-guard
542​	506​	542-506	Labor	Framing a Pole Tangent (T4)	80​
542​	507​	542-507	Labor	Framing a Pole - Block Tangent
542​	508​	542-508	Labor	Framing a Pole Dead End Tangent (Dbl)	26​
542​	509​	542-509	Labor	Framing a Pole Dead End Tangent (single)	26​
542​	511​	542-511	Labor	Install spiral wind dampener during fiber construction PER PAIR
542​	512​	542-512	Labor	Install spiral wind dampener during fiber construction (per dampener)	196​
542​	144EN4-T4S01A20		Material	144 FBR SOLO ADSS CBLE SHORT NESC HEAVY 300 SPAN MEDIUM 500	26,174​	This should populate from F4
542​	144EN4-T4S01A20		Material	144 FBR SOLO ADSS CBLE SHORT NESC HEAVY 300 SPAN MEDIUM 500	508​	This should populate from F2

 

[NoSparks]

Mind telling us how you know 26,174 should populate from F4
and how you know 508 should populate from F2

 

[eechristaylor]

Mind telling us how you know 26,174 should populate from F4
and how you know 508 should populate from F2

The materials are the same part number but the method of them being placed is what is uniquie. One is being placed in air (26,174) and the other is pulled in duct which is buried (508'). The Code (column B) is the uniquie idenifier but I had to create colume C to make it turly uniqie as the job will have many task. I did find out using: =XLOOKUP(A891&"-500",C:C,J:J,"",0) gave me the outcome I desired and for the UG portion I changed the 500 to 415

 

[NoSparks]

I guess that logic makes sense to you.
Afraid I'll have to pass on this.

Good luck with your project.