Spreadsheet: 834864d1688125945-require-help-in-multiple-vlookup-tasl-pan-india-dispatch-report-working-sunilsagar-
Sheet: Reports

WB Store Supply Performance |  |  |  |  |  | Today`s Indent |  |  |  |  | Current Indent (YTD) |  |  |  |  | Vehicles Dispatched |  |  |  |  |  | Days |  | 0 to 3 |  | 3 to 5 |  | > Than 5 |  | Total
State | Stores | Dis.Qty | GRN Qty | GRN% |  | Customer | Indent | Dis.Qty | Pending |  | Customer | Indent | Dis.Qty | Pending |  | State | So Far 2023 |  |  |  |  |  |  | Vehicles | Qty | Vehicles | Qty | Vehicles | Qty | Vehicles | Qty
WB | MMMCCL |  |  |  |  | ITC FBD Coimbatore |  |  |  |  | ITC FBD Coimbatore |  |  |  |  |  | Vehicle | Qty | Vehicle | Qty |  | GJ | ITC FBD Coimbatore
WB | SGS |  |  |  |  | ITC FBD Guwahati |  |  |  |  | ITC FBD Guwahati |  |  |  |  | Customer |  |  |  |  |  | WB | ITC FBD Guwahati
WB | NB |  |  |  |  | ITC FBD Haridwar |  |  |  |  | ITC FBD Haridwar |  |  |  |  | ITC FBD Coimbatore |  |  |  |  |  | GJ | ITC FBD Guwahati
Total |  |  |  |  |  | ITC FBD Medak |  |  |  |  | ITC FBD Medak |  |  |  |  | ITC FBD Guwahati |  |  |  |  |  | GJ | ITC FBD Haridwar
GJ Store Supply Performance |  |  |  |  |  | ITC FBD Mysore |  |  |  |  | ITC FBD Mysore |  |  |  |  | ITC FBD Haridwar |  |  |  |  |  | WB | ITC FBD Medak
State | Stores | Dis.Qty | GRN Qty | GRN% |  | ITC FBD Panchla |  |  |  |  | ITC FBD Panchla |  |  |  |  | ITC FBD Medak |  |  |  |  |  | GJ | ITC FBD Medak
GJ | WC |  |  |  |  | ITC FBD Pune |  |  |  |  | ITC FBD Pune |  |  |  |  | ITC FBD Mysore |  |  |  |  |  | GJ | ITC FBD Mysore
GJ | SA |  |  |  |  | ITC [NAME] |  |  |  |  | ITC [NAME] |  |  |  |  | ITC FBD Panchla |  |  |  |  |  | WB | ITC FBD Panchla
GJ | MCS |  |  |  |  | ITC FBD Vijayawada |  |  |  |  | ITC FBD Vijayawada |  |  |  |  | ITC FBD Pune |  |  |  |  |  | GJ | ITC FBD Panchla
GJ | KP |  |  |  |  | Haldiram Noida |  |  |  |  | Haldiram Noida |  |  |  |  | ITC [NAME] |  |  |  |  |  | GJ | ITC FBD Pune
GJ | JG |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | ITC FBD Vijayawada |  |  |  |  |  | GJ | ITC [NAME]
GJ | GC |  |  |  |  | [NAME] |  |  |  |  | [NAME] |  |  |  |  | Haldiram Noida |  |  |  |  |  | WB | ITC FBD Vijayawada
GJ | SM |  |  |  |  | Tulsi Speciality Guwahati |  |  |  |  | Tulsi Speciality Guwahati |  |  |  |  | [NAME] |  |  |  |  |  | GJ | ITC FBD Vijayawada
GJ | GP |  |  |  |  | Terrestrial Foods GK |  |  |  |  | Terrestrial Foods GK |  |  |  |  | [NAME] |  |  |  |  |  | GJ | Haldiram Noida
Total |  |  |  |  |  | Total |  |  |  |  | Total |  |  |  |  | Tulsi Speciality Guwahati |  |  |  |  |  | WB | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Terrestrial Foods GK |  |  |  |  |  | WB | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  | WB | Tulsi Speciality Guwahati
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WB | Terrestrial Foods GK
 |  | Current Stock Available GJ & WB
State | Stores | TC1 | TC3 | TC10 | 5147 | 5158 | 5177 | 6026 | Hermes | Taurus | Taurus(F) | Winner | LR | Trial | Total
WB | MMMCCL
WB | SGS
WB | NB
GJ | WC
GJ | SA
GJ | MCS
GJ | KP
GJ | JG
GJ | GC
GJ | SM
GJ | GP
Total
Customer | Planned Volume
 | TC1 | TC3 | TC10 | 5147 | 5158 | 5177 | 6026 | Hermes | Taurus | Taurus(F) | Winner | LR | Trial | Total
ITC FBD
Haldiram
[NAME]
Graintech
Tulsi Speciality
Terrestrial
Total
Stored Volume GJ & WB as per buying Report
State | Stores | TC1 | TC3 | TC10 | 5147 | 5158 | 5177 | 6026 | Hermes | Taurus | Taurus (F) | Winner | LR | Trial | Total
WB | MMMCCL
WB | SGS
WB | NB
GJ | WC
GJ | SA
GJ | MCS
GJ | KP
GJ | JG
GJ | GC
GJ | SM
GJ | GP
Total