svcellular
Board Regular
- Joined
- Nov 17, 2015
- Messages
- 75
This is a table from a sheet called "Activations Demo" - There are many tables with similar information in this sheet
I'm aware I may have put in more than enough columns, but my brain is broken.
<colgroup><col style="width: 120px"><col width="120"><col width="61"></colgroup><tbody>
</tbody>
This is a table labeled "Shipped" from a different sheet labeled "ESN List Demo"
<colgroup><col style="width: 93px"><col width="84"><col width="138"></colgroup><tbody>
</tbody>
This is what I'd like done in the new table labeled "Inventory" also in the "ESN List Demo" sheet
<colgroup><col style="width: 120px"><col width="120"><col width="120"></colgroup><tbody>
</tbody>
This is what "Inventory" would look like with the correct formula
<colgroup><col style="width: 120px"><col width="120"><col width="120"></colgroup><tbody>
</tbody> I know there will be blank rows in the above table as well, but I think I've overdone this post as it is.
Might have been an easier way to go about explaining this and giving examples, but I'm new to this stuff, so sorry if I over or under explained anything.
I'm aware I may have put in more than enough columns, but my brain is broken.
12/1/2015 | 1989 | Cow |
12/1/2015 | 1995 | Eagle |
12/1/2015 | 1127 | Marko |
12/2/2015 | 420 | Polo |
12/1/2015 | 1989 | Blue |
12/1/2015 | 1995 | Black |
12/1/2015 | 1127 | Red |
12/2/2015 | 420 | Purple |
12/2/2015 | 1104 | Yellow |
12/3/2015 | 1953 | Orange |
12/3/2015 | 7651 | Indigo |
<colgroup><col style="width: 120px"><col width="120"><col width="61"></colgroup><tbody>
</tbody>
This is a table labeled "Shipped" from a different sheet labeled "ESN List Demo"
10/23/2015 | BM-LGLS751 | Orange |
10/23/2015 | BM-LGLS751 | Monkey |
10/23/2015 | BM-LGLS751 | Dog |
10/23/2015 | BM-LGLS751 | Red |
10/23/2015 | BM-MOT1526 | Blue |
10/23/2015 | BM-MOT1526 | Cow |
<colgroup><col style="width: 93px"><col width="84"><col width="138"></colgroup><tbody>
</tbody>
This is what I'd like done in the new table labeled "Inventory" also in the "ESN List Demo" sheet
Insert A1 from "Shipped" Table if C1 from "Shipped" table is found anywhere in "Activations Demo" Sheet | B1 from "Shipped" Table if C1 from "Shipped" table is found anywhere in "Activations Demo" Sheet | C1 from "Shipped" Table only if the same value is found on any table in "Activations" Sheet |
Insert A2 from "Shipped" Table if C2 from "Shipped" table is found anywhere in "Activations Demo" Sheet | B2 from "Shipped" Table if C2 from "Shipped" table is found anywhere in "Activations Demo" Sheet | C2 from "Shipped" Table only if the same value is found on any table in "Activations" Sheet |
Insert A3 from "Shipped" Table if C3 from "Shipped" table is found anywhere in "Activations Demo" Sheet | B3 from "Shipped" Table if C3 from "Shipped" table is found anywhere in "Activations Demo" Sheet | C3 from "Shipped" Table only if the same value is found on any table in "Activations" Sheet |
<colgroup><col style="width: 120px"><col width="120"><col width="120"></colgroup><tbody>
</tbody>
This is what "Inventory" would look like with the correct formula
10/23/2015 | BM-LGLS751 | Orange |
10/23/2015 | BM-LGLS751 | Red |
10/23/2015 | BM-MOT1526 | Blue |
10/23/2015 | BM-MOT1526 | Cow |
<colgroup><col style="width: 120px"><col width="120"><col width="120"></colgroup><tbody>
</tbody>
Might have been an easier way to go about explaining this and giving examples, but I'm new to this stuff, so sorry if I over or under explained anything.