Blessy Clara
Board Regular
- Joined
- Mar 28, 2010
- Messages
- 201
I have two excel sheets
Sheet 1
<tbody>
</tbody>sheet 2
has transaction data
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 224px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody>Requiremen</body>Requirement - I want to get the quantity sold for a specific product matched with the date and quantity in sheet 2 data
To Note - when the quantity for specific date in not available in sheet 2 - it can be give as n/a
Thank you
Sheet 1
productID | 18-5-2019 | 17-5-2019 | 16-5-2019 | 15-5-2019 | for5 months.... | |
<tbody> </tbody> | =? | = | ||||
<tbody> </tbody> | ||||||
<tbody> </tbody> | ||||||
requirement | ||||||
<tbody> </tbody> | 100 | 0 | 25 | 0 |
<tbody>
</tbody>
has transaction data
productid | date | quantity | ||
<tbody> </tbody> | 18-5-2019 | 100 | ||
<tbody> </tbody> |
<tbody> </tbody> | 25 | ||
<tbody> </tbody> |
<tbody> </tbody> | 1 | ||
<tbody> </tbody> | 15-5-2019 | 500 | ||
32796241751 | 12-5-2019 | 200 | ||
32796241751 | 13-5-2019 | 7 |
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 224px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
18-5-2019 |
<tbody>
</tbody>
To Note - when the quantity for specific date in not available in sheet 2 - it can be give as n/a
Thank you