Hello,
I have this spreadsheet:
<tbody>
</tbody><colgroup><col><col><col></colgroup>
And I need to pick out location for each part and put in the quality, it no quality then I need a zero.
Here is the other spreadsheet I have:
<tbody>
</tbody><colgroup><col><col span="3"></colgroup>
I know that I have my totals work in MAIN column. Not sure if use INDEX or VLOOKUP.
So any help would be appreciate.
Thank you,
Gerald
I have this spreadsheet:
PART_NUM | INV_LOC | QTY_OH |
00000EXP | MAIN | -646 |
0000CART | MAIN | -223 |
0CC00071 | MAIN | -135 |
0CC00091 | MAIN | -18 |
2408 | MAIN | -973 |
28847 | FG | -224 |
A1014 | WHSE | 3143 |
A1015 | WHSE | 2964 |
A1018 | WHSE | 444 |
A1019 | WHSE | 1094 |
A1029 | SERVICE | |
A1103 | WHSE | |
A1113 | FG | 1772 |
A1113STP | PP | |
A1113STP | PROTEC | 6192 |
A1115 | FG | 1442 |
A1117 | FG | 304 |
A1118 | FG | 2160 |
A1118 | REWORK | 142 |
A1120 | FG | |
A1120 | WHSE | 1500 |
A1121 | FG | 13 |
A1121 | REWORK | 150 |
A1140 | FG | 7110 |
A1153 | FG | |
A1153AB | MAIN | |
A1153AD | FG | 590 |
A1155 | FG | 220 |
A1155 | WHSE | |
A1156 | FG | 59 |
A1162 | FG | 92 |
A1163 | FG | 657 |
A1163 | WHSE | 982 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>
And I need to pick out location for each part and put in the quality, it no quality then I need a zero.
Here is the other spreadsheet I have:
PART_NUM | MAIN | FG | WIP |
A1113 | 1772 | ||
A1113STP | 0 | ||
A1115 | 1442 | ||
A1118 | 2160 | ||
A1140 | 7110 | ||
A1140STP | 0 | ||
A1153AB | 0 | ||
A1153AC | 0 | ||
A1153AD | 590 | ||
A1186 | 0 | ||
A1193STP | 0 | ||
A1193TOG | 0 | ||
A1193WELD | 0 | ||
A1194 | 583 | ||
A1252AB | 0 | ||
A1252AC | 6091 | ||
A1293STP | 0 | ||
A1325AA | 2916 | ||
A1325AB | 0 | ||
A1326AA | 621 | ||
A1327AA | 0 | ||
A1327STPAA | 3670 | ||
A2100STPAC | 0 | ||
A2100STPAD | 0 | ||
A2101AC | 0 | ||
A2101AD | 0 | ||
A2101AE | 1107 | ||
B1051 | 7901 | ||
B1069AB | 0 | ||
B1071AB | 0 | ||
B1072AB | 0 | ||
B1074AB | 0 |
<tbody>
</tbody><colgroup><col><col span="3"></colgroup>
I know that I have my totals work in MAIN column. Not sure if use INDEX or VLOOKUP.
So any help would be appreciate.
Thank you,
Gerald