Jul 24 2019 09:46 AM
i just want give discount to the students mentioned in sheet 2 . and i have to map the students on sheet1 . what can we the possible solution.
i was looking if i could bring the same number in front of the same column through some formula.
please help me out..?
Jul 24 2019 02:02 PM
SolutionYou may use VLOOKUP or INDEX/MATCH like
=IFERROR(INDEX('sheet 2'!$D:$D,MATCH($C3,'sheet 2'!$A:$A,0)),"no such")
Jul 24 2019 07:15 PM
@Sergei Baklan Thank you so much sir. i am highly obliged to you for the formula.
Jul 25 2019 02:18 AM
@aayushman_mishra , you are welcome
Jul 24 2019 02:02 PM
SolutionYou may use VLOOKUP or INDEX/MATCH like
=IFERROR(INDEX('sheet 2'!$D:$D,MATCH($C3,'sheet 2'!$A:$A,0)),"no such")