Spreadsheet: 716683d1612320701-vlookup-multiple-values-index-please-help-sample-file
Sheet: Sheet1

SKU |  |  |  |  |  | Location |  |  | Total Qty | All Locations
APP 127 | APP127 | (26) OEM Whirlpool Refrigerator [NAME] W10371195 | marc | Universal | 1W | 3D2 | 4 | 3D2 | https://exceljet.net/excel-functions/excel-sumif-function
APP 128 | APP128 | (34) OEM Whirlpool WP3395382 | marc | Universal | 1W | 3D1 | 7 | 3D1 | https://exceljet.net/excel-functions/excel-sumif-function
APP 129 | APP129 | (30) OEM (NOT APP 070) Mixer Beater WPW10731415 | sund | Universal | 1W | 3D1 | 3 | 3D1 | https://exceljet.net/excel-functions/excel-sumif-function
APP 130 | APP130 | (36) OEM GE Dryer Timer WE4M533 TMD1EM03 | ued | Genteq | 1W | 3D1 | 145 | 3D1 | https://exceljet.net/excel-functions/excel-sumif-function
APP 132 | APP132 | (24A)OEM LG  Venting Kit 3911EZ9131X | ued | Universal | 1W | 12P-0 | 378 | 12P-0 | https://exceljet.net/excel-functions/excel-sumif-function
APP 134 | WE4M527 | (35) OEM GE Dryer Timer WE4M527 | ued | Genteq | 1W | 3D1 | 25 | 3D1 | https://exceljet.net/excel-functions/excel-sumif-function
APP 134 | WE4M527 | (35) OEM GE Dryer Timer WE4M527 | ued | Genteq | 4H | CS USED | 2 | 3D1 | https://exceljet.net/excel-functions/excel-sumif-function
APP 135 | WR21X10208 | (37) OEM GE  [NAME] WR21X10208 | ued | Genteq | 1W | 3F2 | 38 | 3F2 | https://exceljet.net/excel-functions/excel-sumif-function
APP 136 | APP136 | (22A) CB [PHONE] Oven Board | marc | Universal | 1W | 3D2 | 8 | 3D2 | https://exceljet.net/excel-functions/excel-sumif-function
APP 138 | [NAME] | (19) OEM Samsung Door Lock Switch DC64-00519B / 8182634 (Samsung/Whirlpool) (ALT# WDLS519B) | Unknown | Universal | 1W | 3D2 | 363 | 3D2 | https://exceljet.net/excel-functions/excel-sumif-function | 3D2, H-10E1
APP 138 | [NAME] | (19) OEM Samsung Door Lock Switch DC64-00519B / 8182634 (Samsung/Whirlpool) (ALT# WDLS519B) | Unknown | Universal | 4H | H-10E1 | 288 | 3D2 | https://exceljet.net/excel-functions/excel-sumif-function | 3D2, H-10E1
APP 140 | APP140 | (9) OEM LG Microwave Magnetron 2M246-01TAG (ALT# 6324W1A001H) | vect | Universal | 1W | 3B2 | 81 | 3B2 | https://exceljet.net/excel-functions/excel-sumif-function
APP 144 | WE04X20089 | (1)OEM GE Dryer Timer WE04X20089 TMD1CM11 | sund | Genteq | 1W | 3F1 | 15 | 3F1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 220 | ASX99220 | AS Endura ES2312-1001 (CS- [NAME] GMAN 20197311 - ASX02 045) | Unknown | Endura | 1W | 7DA1 | 65 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 221 | ASX99221 | AS Endura ??? (CS- [NAME] GMAN 10727920 - ASX02 017) | Unknown | Endura | 1W | 7DA1 | 147 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 222 | ASX99222 | AS Endura ES2256-1022 (CS- [NAME] GMAN 0130F00041 - ASX02 021) | endu | Endura | 1W | 7DA1 | 289 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 301 | [NAME] | AS Endura ES2257-0867 (CS- [NAME] YORK 324-35972-000 - ASX03 002) | endu | Endura | 1W | 7DA1 | 327 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 301 | [NAME] | AS Endura ES2257-0867 (CS- [NAME] YORK 324-35972-000 - ASX03 002) | endu | Endura | 1W | 7DA2 | 2 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 302 | [NAME] | AS Endura ES2264-0877 (CS- [NAME] YORK S1-024-35271-000 - ASX03 011) | endu | Endura | 1W | 7DA1 | 158 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 303 | ASX99303 | AS Endura ES2265-0878 (CS- [NAME] YORK S1-024-35261-000 - ASX03 037) | endu | Endura | 1W | 7DA1 | 419 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 304 | ASX99304 | AS Endura ES2265-0884 (CS- [NAME] YORK S1-024-35262-000 - ASX03 042) | endu | Endura | 1W | 7DA1 | 271 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 305 | ASX99305 | AS Endura ES2265-0923 (CS- [NAME] YORK S1-024-35308-000 - ASX03 016) | endu | Endura | 1W | 7DA1 | 278 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 306 | ASX99306 | AS Endura ES2265-0924 (CS- [NAME] YORK S1-024-27634-001 - ASX03 019) | endu | Endura | 1W | 7DA1 | 96 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
ASX99 307 | ASX99307 | AS Endura XP (CS- [NAME] YORK S1-024-35272-000 - ASX03 014)Sensors | endu | Endura | 1W | 7DA1 | 264 | 7DA1 | https://exceljet.net/excel-functions/excel-sumif-function
BLT70 A76 | 746041001308 | [NAME] 78'' 4L780 (ALT# A76/4L780) | mega | [NAME] | 1W | 7H1 | 5 | 7H1 | https://exceljet.net/excel-functions/excel-sumif-function
BLT70 A77 | 746041001315 | [NAME] 79'' 4L790 (ALT# A77/4L790) | mega | [NAME] | 1W | 7H1 | 21 | 7H1 | https://exceljet.net/excel-functions/excel-sumif-function
BLT70 A78 | 746041001322 | [NAME] 80'' 4L800 (ALT# A78/4L800) | mega | [NAME] | 1W | 7H1 | 44 | 7H1 | https://exceljet.net/excel-functions/excel-sumif-function
BLT70 A79 | 746041001339 | [NAME] 81'' 4L810 (ALT# [NAME]) | mega | [NAME] | 1W | 7H0 | 17 | 7H0 | https://exceljet.net/excel-functions/excel-sumif-function
BLT70 A80 | 746041001346 | [NAME] 82'' 4L820 (ALT# A80/4L820) | mega | [NAME] | 1W | 7H0 | 547 | 7H0 | https://exceljet.net/excel-functions/excel-sumif-function | 7H0, 8W1, H-10G1
BLT70 A80 | 746041001346 | [NAME] 82'' 4L820 (ALT# A80/4L820) | mega | [NAME] | 1W | 8W1 | 4 | 7H0 | https://exceljet.net/excel-functions/excel-sumif-function
BLT70 A80 | 746041001346 | [NAME] 82'' 4L820 (ALT# A80/4L820) | mega | [NAME] | 4H | H-10G1 | 130 | 7H0 | https://exceljet.net/excel-functions/excel-sumif-function
BLT70 A81 | 746041001353 | [NAME] 83'' 4L830 (ALT# [NAME]) | mega | [NAME] | 1W | 7H0 | 135 | 7H0 | https://exceljet.net/excel-functions/excel-sumif-function
BLT70 A82 | 746041001360 | [NAME] 84'' 4L840 (ALT# A82/4L840) | mega | [NAME] | 1W | 7H0 | 114 | 7H0 | https://exceljet.net/excel-functions/excel-sumif-function