get complex data from other xls file

[irealtymods]

i need your help to get data from other file
i tried lookup, but not sure how to get more data.

so i have file where from i need data.
in A5:A500 components numbers
in B5:B500 its description
in cell K4, N4, Q4, T4, W4 - there are week numbers.
in columns L4, O4, R4, U4, X4 - how many components will come.

so in other file id like to create table with next conditions:
if i'll write components number in K28, so formula will check data file and
fill
in F28 nearest week number when components are coming.
in H28 how many components.
in L28 its description.

thank you for your help, i really need it.

 

[irealtymods]

remark*
in columns L, O, R, U, X

sorry

 

[irealtymods]

please i need your help, i know its simple