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..?
View best response
You may use VLOOKUP or INDEX/MATCH like
=IFERROR(INDEX('sheet 2'!$D:$D,MATCH($C3,'sheet 2'!$A:$A,0)),"no such")
@Sergei Baklan Thank you so much sir. i am highly obliged to you for the formula.
@aayushman_mishra , you are welcome