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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 13, 2021 at 11:43 AM
Related:
- Copy adjacent Columns in excel if the ID numbers same
- Numbers to words in excel - Guide
- Gif in excel - Guide
- Marksheet in excel - Guide
- How to take screenshot in excel - Guide
- Display two columns in data validation list but return only one - Guide
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
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
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