SOLVED

bulk data reconciliation want to map the numbers in front of the same number

Copper Contributor

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..?

3 Replies
best response confirmed by aayushman_mishra (Copper Contributor)
Solution

@aayushman_mishra 

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.

1 best response

Accepted Solutions
best response confirmed by aayushman_mishra (Copper Contributor)
Solution

@aayushman_mishra 

You may use VLOOKUP or INDEX/MATCH like

=IFERROR(INDEX('sheet 2'!$D:$D,MATCH($C3,'sheet 2'!$A:$A,0)),"no such")

View solution in original post