Forum Discussion
Solved
bulk data reconciliation want to map the numbers in front of the same number
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...
You may use VLOOKUP or INDEX/MATCH like
=IFERROR(INDEX('sheet 2'!$D:$D,MATCH($C3,'sheet 2'!$A:$A,0)),"no such")
You may use VLOOKUP or INDEX/MATCH like
=IFERROR(INDEX('sheet 2'!$D:$D,MATCH($C3,'sheet 2'!$A:$A,0)),"no such")
SergeiBaklan Thank you so much sir. i am highly obliged to you for the formula.
aayushman_mishra , you are welcome