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