nabeelahmed
Board Regular
- Joined
- Jun 19, 2020
- Messages
- 76
- Office Version
- 365
- Platform
- Windows
Hi Friends,,, Hope alss well... I am working on book where i have 2 sheets Lookup Data sheet is "Tools & Consumables" and where i want to extract data is"Issuance"
- I want that in sheet "Issuance"when i will enter Tag# 5737 in cell E6 the description in cell F6 & Unite Price in cell M6 should be extracted from data sheet from older entry first with having some balance on hand and when that balance finished then data should be extracted from the next entry and so on...
Thanks & REgards,
- I want that in sheet "Issuance"when i will enter Tag# 5737 in cell E6 the description in cell F6 & Unite Price in cell M6 should be extracted from data sheet from older entry first with having some balance on hand and when that balance finished then data should be extracted from the next entry and so on...
Thanks & REgards,
Spares & Consumable Register.xlsx | |||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
L | T | U | AC | AD | |||||||||||||||||
3 | Description of spare parts | received date | Tag # | Balance on Hand | Unit Price | ||||||||||||||||
4 | Bechem Berulub VPN 13 | 1-Oct-2019 | 5737 | 10 | 5000 | ||||||||||||||||
5 | EPTFE Gasket 3mm 1" 150lbs RF ANSI B16.21 Spira | 1-Oct-2019 | 8579 | 5 | |||||||||||||||||
6 | Cylindrical Roller Bearing NU306 ECP SKF | 1-Oct-2019 | 7415 | 2 | |||||||||||||||||
7 | Bearing 7306 BECEP SKF | 1-Oct-2019 | 7416 | 3 | |||||||||||||||||
8 | Shaft OD 34x380 mm L SS Fabricated as per Sample | 1-Oct-2019 | DI3867 | 1 | |||||||||||||||||
9 | Bechem Berulub VPN 13-1 | 1-Sep-2020 | 5737 | 14 | 4950 | ||||||||||||||||
10 | EPTFE Gasket 3mm 1" 150lbs RF ANSI B16.21 Spira | 1-Sep-2020 | 8579 | 47 | |||||||||||||||||
11 | PTFE Gore Ring Gasket 1.5" x 3mm #150 | 1-Sep-2020 | 2006 | 25 | |||||||||||||||||
12 | Bearing 7306 BECEP SKF | 1-Sep-2020 | 7416 | 22 | |||||||||||||||||
13 | Shaft OD 34x380 mm L SS Fabricated as per Sample | 1-Sep-2020 | DI3867 | 11 | |||||||||||||||||
14 | Bechem Berulub VPN 13-2 | 3-Sep-2020 | 5737 | 5 | 4700 | ||||||||||||||||
Tools & Consumables |