Spreadsheet: 683177d1592542176-with-the-combination-of-two-selections-get-all-the-values-pertaining-to-them-in-excel-taptrial
Sheet: Print Report

Trial
Select Emp. No. | Select Set No. |  |  |  |  |  |  |  | Select this cells
20334 | 2
 |  |  | Previous  Set No. | Count of Lines
 |  | Laptop | Printer | Printer
 |  | #N/A
Total expenditure of Rs. |  | 0 | have been incurred by me towards the purchase of the followings  under
the extant provisions of Scheme of Electronic Device Facility of the Company as per the details given below.
Item/Particulars |  | Laptop | Printer | Printer
Make / Brand |  | 0 | 0 | 0 | 0
Model No. |  | 0 | 0 | 0 | 0
Serial No. |  | 0 | 0 | 0 | 0
Specification |  | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0
[NAME]/Invoice No. & Date |  | 0 | 0 | 0 | 0
Money Receipt No. and Date |  | 0 | 0 | 0 | 0
Incurred Cost (Rs.) |  | 0 | 0 | 0 | 0
Asset No. (To be given by Stores) |  | SAL/OE-C/19-20/ | SAL/OE-C/19-20/ | SAL/OE-C/19-20/ | SAL/OE-C/19-20/
Repair & maintenance  :
Insurance detail  :
Earlier purchased details : |  |  | 1 | 2
Previous  Items |  | Previous items Make | Previous Date of Purchse |  | Previous  Items ( tried in this way also)
Lptop |  | #N/A | 2018-06-27 00:00:00 |  | Lptop
Lptop |  | #N/A | #N/A |  | #N/A
 |  | __ |  |  | #N/A
 |  | __ |  |  | #N/A
 |  | __ |  |  | #N/A
Total cost incurred in previous purchases ( in Rs) |  |  |  |  | #N/A
(FOR OFFICE USE ONLY)
The above Items and Related Documents have been verified with the original and found to be in order. Approved amount for reimbursement as under.
Laptop |  | Printer | Printer |  | Total Amount (Rs.)
#N/A |  |  | 0 | 0 | #N/A
Previous purchase reinbursment details
Laptop |  | Printer | Printer |  | Total Amount (Rs.)
#N/A |  | #N/A | #N/A | #N/A | #N/A
S Sujith, Manager, प्रबंधक |  | सहायक प्रबन्धक (परिवीक्षाधीन) | AGM | सह महाप्रबंधक | DGM | उप महाप्रबंधक
The General Manager
BRBNMPL, Salboni
West Midnapore ,West Bengal
Dear Sir,
Sub: Reimbursement Request & Declaration towards the purchase of Laptop
Ref: CO Circular No 7(BNM. C-12/02.02.14/2017-18)dtd. April 18, 2017 regarding “Scheme of Electronic Device Facility”
I have purchased a |  | Laptop,[NAME],[NAME],
*   I may kindly be reimbursed the eligible amount as per the CO. Circular 7(BNM.C-12/02.02.14/2017-18)dtd. 18.04.2017
*   I declare, that the above [NAME] (s) are actually bought by me, and shall not be in possession of any person other than me and
the devices shall be used for official purpose only (under clause: 3/3.7).
*   I agree that the item(s) purchased will be submitted physically for verification/scrutiny at any time decided by the company.
*   I declare that Repairs & maintenance, insurance etc. of the electronic device bought shall be taken care by me. I shall also
arrange for  alternative electronic device in case the existing device(s) are lost/damaged beyond repair during the three year
period.(Under clause:3/3.6).
Thanking you.
Yours faithfully,
Signature:
Name : |  | 0
Emp.No : |  | 20334
Designation : |  | 0
Encl : |  | Invoices / Money receipt / Bank Statement / Bank POS Slip
Place : |  | Salboni
Date : |  | #N/A
"PartData" sheet  stores data and data is fecthed from here.  Print Report is the sheet where I select Emp No & Set No and get the data automatically  in A23 to [NAME]. When I select Emp no & Set No (A3 & B3) ,  it automatically fetches Previous  Set No. (in D22) & Count of Lines (in F22 - number of lines the combinaiton of emp no & set have) from the PartData Sheet.   I need help on the followings : With the combination of Emp no (A4 ) and Previous  Set No.( D22) and I want to get values of  Previous  Items (the data will come from PartData: Column D:D),  Previous items Make  (the data will come from PartData: Column J:J),  Previous Expense (the data will come from PartData: Column H:H)  A sample file is attached for your kind perusal. Please help me.