Hello,
In EXCEL using formulae in the example below, how may I populate Table1 with the data from Table 2. I tried Index Match but was unsuccesful.
<colgroup><col><col><col><col span="6"><col><col span="2"><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
In EXCEL using formulae in the example below, how may I populate Table1 with the data from Table 2. I tried Index Match but was unsuccesful.
| TABLE 1 | TABLE 2 | ||||||||||||||||
| Vehicle | DATES | Date | Day | SMA | Area | Vehicle | No of Vehicle | Version | Status | ITMP | |||||||
| Area | London | EV | "Date" | "Date" | "Date" | "Date" | 13/12/2018 | Thu | SMA1 | London | S7 | 2 | 4.08.82 | USED | |||
| London | S8 | "Date" | "Date" | "Date" | "Date" | 15/12/2018 | Sat | SMA0.5 | Birmingham | EV | 1 | 4.08.82/4.08.76 | USED | ||||
| London | S7 | "Date" | "Date" | "Date" | "Date" | 16/12/2018 | Sun | SMA1 | Manchester | S7 | 2 | 4.08.82 | Cancelled | ||||
| Birmingham | EV | "Date" | "Date" | "Date" | "Date" | 18/12/2018 | Tue | SMA3 | Liverpool | S7 & S8 | 1 | 4.08.82 | Cancelled | ||||
| Birmingham | S8 | "Date" | "Date" | "Date" | "Date" | 20/12/2018 | Thu | SMA3 | Newcastle | S8 | 1 | 4.08.82 | Cancelled | ||||
| Birmingham | S7 | "Date" | "Date" | "Date" | "Date" | 22/12/2018 | Sat | SMA2 | Birmingham | EV | 1 | 4.08.82/4.08.76 | Cancelled | ||||
| Manchester | EV | "Date" | "Date" | "Date" | "Date" | 23/12/2018 | Sun | SMA1 | Liverpool | S7 | 2 | 4.08.82 | Cancelled | ||||
| Manchester | S8 | "Date" | "Date" | "Date" | "Date" | 05/02/2019 | Tue | SMA3 | Manchester | S8 | 1 | 4.08.82/4.13.00 | USED | 110 | |||
| Manchester | S7 | "Date" | "Date" | "Date" | "Date" | 12/02/2019 | Tue | SMA3 | Birmingham | S8 | 1 | 4.13.00 | USED | 110 | |||
| Liverpool | EV | "Date" | "Date" | "Date" | "Date" | 16/02/2019 | Sat | SMA0.5 | London | EV | 2 | 4.13.00/4.08.76 | Cancelled | 106 | |||
| Liverpool | S8 | "Date" | "Date" | "Date" | "Date" | 19/02/2019 | Tue | SMA3 | Birmingham | S7 | 1 | 4.13.00 | USED | 110 | |||
| Liverpool | S7 | "Date" | "Date" | "Date" | "Date" | 23/02/2019 | Sat | SMA2 | Liverpool | EV | 1 | 4.13.00/4.08.76 | Cancelled | 115 | |||
| NewCastle | EV | "Date" | "Date" | "Date" | "Date" | 26/02/2019 | Tue | SMA3 | Glasgow | S7 | 1 | 4.13.00 | USED | 110 | |||
| NewCastle | S8 | "Date" | "Date" | "Date" | "Date" | 28/02/2019 | Thu | SMA0.5 | Glasgow | S7 | 2 | 4.13.00 | Cancelled | 99 | |||
| NewCastle | S7 | "Date" | "Date" | "Date" | "Date" | 02/03/2019 | Sat | SMA0.5 | HMS | 4.13.00 | USED | N/A | |||||
| Glasgow | EV | "Date" | "Date" | "Date" | "Date" | 05/03/2019 | Tue | SMA3 | London | S8 | 1 | 4.13.00 | Cancelled | 111 | |||
| Glasgow | S8 | "Date" | "Date" | "Date" | "Date" | 12/03/2019 | Tue | SMA3 | Newcastle | S8 | 1 | 4.13.00 | Cancelled | 111 | |||
| Glasgow | S7 | "Date" | "Date" | "Date" | "Date" | 16/03/2019 | Sat | SMA0.5 | HMS | 4.13.00 | USED | Go LIVE | |||||
| 19/03/2019 | Tue | SMA3 | Birmingham | S7 | 1 | 4.13.00 | Cancelled | 110 | |||||||||
| 21/03/2019 | Thu | SMA3 | Manchester | S7 | 1 | 4.13.00 | Cancelled | 110 | |||||||||
| 23/03/2019 | Sat | SMA2 | London | EV | 1 | 4.13.00/4.08.76 | Cancelled | 115 | |||||||||
| 26/03/2019 | Tue | SMA3 | Liverpool | S7 | 2 | 4.13.00 | Cancelled | 110 | |||||||||
| 28/03/2019 | Thu | SMA3 | Manchester | S8 | 1 | 4.13.00 | Cancelled | 111 | |||||||||
| 30/03/2019 | Sat | SMA0.5 | London | S7 | 2 | 4.13.00 | CONFIRMED | 95 | |||||||||
| 31/03/2019 | Sun | SMA0.5 | Manchester | EV | 2 | 4.13.00/4.08.76 | Cancelled | 106 | |||||||||
| 02/04/2019 | Tue | SMA3 | Manchester | S7 | 2 | 4.13.00 | CONFIRMED | 111 | |||||||||
| 04/04/2019 | Thu | SMA3 | Liverpool | S7 | 2 | 4.13.00 | CONFIRMED | 111 | |||||||||
| 06/04/2019 | Sat | SMA0.5 | London | S7 | 2 | 4.13.00 | CONFIRMED | ||||||||||
| 06/04/2019 | Sat | SMA0.5 | London | S7 | 2 | 4.13.00 | Cancelled | ||||||||||
| 09/04/2019 | Tue | SMA2 | Glasgow | S8 | 2 | 4.13.00 | Cancelled | 111 | |||||||||
| 11/04/2019 | Thu | SMA3 | Newcastle | S8 | 2 | 4.13.00 | Cancelled | 111 | |||||||||
| 13/04/2019 | Sat | SMA2 | Newcastle | EV | 2 | 4.13.00/4.08.76 | Cancelled | NEW | |||||||||
| 16/04/2019 | Tue | SMA2 | Glasgow | S7 | 2 | 4.13.00 | CONFIRMED | 111 | |||||||||
| 18/04/2019 | Thu | SMA3 | Newcastle | S7 | 1 | 4.13.10 | Cancelled | 111 | |||||||||
| 19/04/2019 | Fri | N/A | NewCAstle | ||||||||||||||
| 20/04/2019 | Sat | SMA2 | Glasgow | S8 | 1 | 4.13.10 | CONFIRMED | NEW | |||||||||
| 22/04/2019 | Mon | N/A | Manchester | ||||||||||||||
| 23/04/2019 | Tue | SMA2 | Glasgow | S8 | 1 | 4.13.10 | CONFIRMED | NEW | |||||||||
| 23/04/2019 | Tue | SMA2 | Manchester | EV | 1 | 4.13.00/4.08.76 | Cancelled | 115 | |||||||||
| 25/04/2019 | Thu | SMA2 | Glasgow | S8 | 1 | 4.13.10 | CONFIRMED | ||||||||||
| 30/04/2019 | Tue | SMA3 | Newcastle | S7 | 2 | 4.13.10 | Requested | ||||||||||
| 02/05/2019 | Thu | SMA3 | Newcastle | S8 | 2 | 4.13.10 | Requested | ||||||||||
| 06/05/2019 | Mon | N/A | Manchester | ||||||||||||||
| 11/05/2019 | Sat | SMA3 | Liverpool | S7 & S8 | 4 | 4.13.10 | CONFIRMED | ||||||||||
| 14/05/2019 | Tue | SMA2 | Cardiff | EV | 1 | 4.13.10/4.13.11 | Requested | ||||||||||
| 16/05/2019 | Thu | SMA0.5 | Liverpool | EV | 1 | 4.13.00 | Requested | ||||||||||
| 18/05/2019 | Sat | SMA0.5 | Liverpool | EV | 1 | 4.13.00 | Requested | ||||||||||
| 21/05/2019 | Tue | SMA2 | Manchester | EV | 1 | 4.13.10/4.13.11 | Requested | ||||||||||
| 23/05/2019 | Thu | SMA3 | NewCAstle | S8 | 1 | 4.13.10 | Requested | ||||||||||
| 28/05/2019 | Tue | SMA2 | Glasgow | S7 | 1 | 4.13.10 | Requested | ||||||||||
| 30/05/2019 | Thu | SMA3 | NewCAstle | S7 | 2 | 4.13.10 | Requested | ||||||||||
| 31/05/2019 | Fri | SMA2 | London | 4.13.00 | CONFIRMED | ||||||||||||
| 01/06/2019 | Sat | SMA2 | London | S8 | 2 | 4.13.10 | Requested | ||||||||||
| 02/06/2019 | Sun | SMA2 | Birmingham | EV | 2 | 4.13.10/4.13.11 | Requested | ||||||||||
| 04/06/2019 | Tue | SMA2 | Manchester | S7 | 1 | 4.13.10 | Requested | ||||||||||
| 06/06/2019 | Thu | SMA4 | Liverpool | S7 | 2 | 4.13.10 | To Plan | ||||||||||
| 07/06/2019 | Fri | SMA5 | Newcastle | 4.13.20 | SSRR | ||||||||||||
| 09/06/2019 | Sun | SMA2 | Manchester | S7 & S8 | 4 | 4.13.20 | CONFIRMED | ||||||||||
| 11/06/2019 | Tue | SMA3 | London | EV | 2 | 4.13.20/4.13.11 | Requested | ||||||||||
| 15/06/2019 | Sat | SMA5 | Cardiff | S7 & S8 & EV | 4+1 | 4.13.20 | CONFIRMED | ||||||||||
| 20/06/2019 | Thu | SMA4 | London | S8 | 2 | 4.13.20 | Requested | ||||||||||
| 22/06/2019 | Sat | SMA2 | Cardiff | S7 | 2 | 4.13.20 | Requested | ||||||||||
| 23/06/2019 | Sun | SMA0.5 | Liverpool | S7 | 2 | 4.13.20 | Requested | ||||||||||
| 25/06/2019 | Tue | SMA4 | NewCAstle | S7 | 2 | 4.13.20 | Requested | ||||||||||
| 27/06/2019 | Thu | SMA4 | NewCAstle | S8 | 2 | 4.13.20 | Requested | ||||||||||
| 29/06/2019 | Sat | SMA2 | Cardiff | S7 | 2 | 4.13.20 | Requested | ||||||||||
| 02/07/2019 | Tue | SMA0.5 | Liverpool | S7 | 2 | 4.13.20 | Requested | ||||||||||
| 07/07/2019 | Sun | SMA2 | Liverpool | S7 & S8 | 4 | 4.13.20 | CONFIRMED | ||||||||||
| 11/07/2019 | Thu | SMA3 | Liverpool | EV | 1 | 4.13.20/4.13.11 | Requested | 115 | |||||||||
| 13/07/2019 | Sat | SMA2 | Cardiff | S8 | 1 | 4.13.20 | Requested | ||||||||||
| 13/07/2019 | Sat | SMA2 | Cardiff | S8 | 1 | 4.13.20 | Requested | ||||||||||
| 13/07/2019 | Sat | SMA2 | Manchester | S8 | 1 | 4.13.20 | Requested | ||||||||||
| 25/07/2019 | Thu | SMA | NewCAstle | EV | 2 | 4.13.20/4.14.01 | Requested | ||||||||||
| 27/07/2019 | Sat | SMA2 | Cardiff | S8 | 2 | 4.13.20 | Requested | ||||||||||
| 01/08/2019 | Thu | SMA3 | Manchester | EV | 2 | 4.13.20/4.14.01 | Requested | ||||||||||
| 03/08/2019 | Sat | SMA2 | Cardiff | S8 | 1 | 4.13.20 | Requested | ||||||||||
| 08/08/2019 | Thu | SMA3 | Glasgow | EV | 2 | 4.13.20/4.14.01 | Requested | ||||||||||
| 10/08/2019 | Sat | SMA3 | Liverpool | S7 & S8 | 4 | 4.13.20 | REQUESTED | ||||||||||
| 10/08/2019 | Sat | SMA3 | Liverpool | S7 & S8 | 4 | 4.13.20 | REQUESTED | ||||||||||
| 17/08/2019 | Sat | SMA4 | Manchester | S7 & S8 | 4 | 4.14.00 | REQUESTED | ||||||||||
| 22/08/2019 | Thu | SMA3 | Glasgow | EV | 2 | 4.14.00/4.14.01 | Requested | ||||||||||
| 01/01/1900 | Mon | N/A | Manchester | ||||||||||||||
| 29/08/2019 | Thu | SMA3 | London | EV | 2 | 4.14.00/4.14.01 | Requested |
<colgroup><col><col><col><col span="6"><col><col span="2"><col><col><col><col><col span="2"></colgroup><tbody>
</tbody>
