Copy adjacent Columns in excel if the ID numbers same

Solved/Closed
Ganesh_131 Posts 2 Registration date Friday August 25, 2017 Status Member Last seen December 8, 2021 - Updated on Dec 8, 2021 at 04:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 13, 2021 at 11:43 AM
Dear all,

I have ONE HELP in excel to copy two columns data( Qty & Amount ) from another sheet if the ID numbers are same..

I have created one sheet with the name of "Target sheet" that have all employee details
&I have created another sheet with the name of support sheet.

I want to a formula that if "ID No" are same then Qty and Amount should be copied from support sheet to target sheet.

Also

I want to take attendance of the employee in the same file( Attendance sheet) . so kindly assist me to ta take from "ID No " are same then it will give 1 or P(present), 0 or A(Absent)..

sample document attached dropbox link:
https://www.dropbox.com/scl/fi/8ycbjgikm5djfcwgyca8a/sample-sheet-to-wrok.xlsx?dl=0&rlkey=mkmyz1lfo0n66c7vakxlq9qak

Thanks & Regards,
Ganesh
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 13, 2021 at 11:43 AM
Hi Ganesh,

For your first question you have to include the entire source matrix in the VLOOKUP function.
You have: =VLOOKUP(B74,'Support sheet'!$B$3:$B72,2,FALSE)
Which should be (for "qty wotk"): =VLOOKUP(B74,'Support sheet'!$B$3:$D72,2,FALSE)
For "amount" change the 2 into a 3: =VLOOKUP(B74,'Support sheet'!$B$3:$D72,3,FALSE)

For your second question you could do something like this on the attendence sheet:
=IF('TARGET SHEET DEC-21'!H74="",0,1) for the same ID no 75 for the 1st of december.

Best regards,
Trowa
0