Attachments
-
You do not have permission to view the full content of this post. Log in or register now.
size 24 ni baklaran na may 15369 na stock numberanung qty ba gusto mu lumabas jan sa cell D10 ng S.O. excel file?
dpat ang output qty nya is "2", based from cell K14 ng fitting excel fitatangalin po ba ung + asd
naka ling na po naka validate na po ung data sirdpat same pla na [fitting.xlsx]Sheet2! yung reference mu.
link mu nlng paps, anjan n yung
edit mu nlng yang "fitting.xlsx" nung mismong file name mu. bka hndi kasi match
blanko po sir ung sheet 2 po ung template ko ng stores and qty tas ung sheet 1 category and price ok na po ako sa sheet 1=IFERROR(INDEX([fitting.xlsx]Sheet1!$D:$D,MATCH(A10,[fitting.xlsx]Sheet1!$A:$A,0)),"") yan nga patry
considering na gusto mung makuhang qty is from column D (cellD4 = 1499.75) ng sheet1 ng fitting excel file
bet mo ?? hehepawards