Hi!
I have the followin data.
A B C D E F g
SB No KW Mot_No FrB_No qty rea_br Qty
1 0.37 2 6202 2 6202 2
1 0.75 6 6204 6 6203 6
1 1.1 11 6205 11 6205 11
2 2.2 3 6306 3 6206 3
2 5.5 3 6307 3 6207 3
2 18.5 4 6310 4 6210 4
1 22 8 6310 8 6308 8
1 30 2 6213 2 6211 2
3 37 1 6312 1 6212 1
3 55 1 Nu217 1 6217 1
3 75 3 6316 3 6316 3
1 300 3 6322 3 6322 3
i need that if enter bR_No,SBNo then it return qty form both column of qty where Br= 6202. Where 6202 exist in both column"D" & "F" and qty in column "E" & "H"
BR_No SB NO Qty expected result
6202 1 ? 4
6213 3 ? 2
6322 1 ? 6
Thanks and regards
Bookmarks