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 of the same column through some formula.
please help me out..?
You may use VLOOKUP or INDEX/MATCH like
=IFERROR(INDEX('sheet 2'!$D:$D,MATCH($C3,'sheet 2'!$A:$A,0)),"no such")
3 Replies
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
