SOLVED
Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-771962%22%20slang%3D%22en-US%22%3Ebulk%20data%20reconciliation%20want%20to%20map%20the%20numbers%20in%20front%20of%20the%20same%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-771962%22%20slang%3D%22en-US%22%3E%3CP%3Ei%20just%20want%20give%20discount%20to%20the%20students%20mentioned%20in%20sheet%202%20.%20and%20i%20have%20to%20map%20the%20students%20on%20sheet1%20.%20what%20can%20we%20the%20possible%20solution.%3CBR%20%2F%3Ei%20was%20looking%20if%20i%20could%20bring%20the%20same%20number%20in%20front%20of%20the%20same%20column%20through%20some%20formula.%3CBR%20%2F%3E%3CBR%20%2F%3Eplease%20help%20me%20out..%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-771962%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-772469%22%20slang%3D%22en-US%22%3ERe%3A%20bulk%20data%20reconciliation%20want%20to%20map%20the%20numbers%20in%20front%20of%20the%20same%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-772469%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381563%22%20target%3D%22_blank%22%3E%40aayushman_mishra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20use%20VLOOKUP%20or%20INDEX%2FMATCH%20like%3C%2FP%3E%0A%3CPRE%3E%3DIFERROR(INDEX('sheet%202'!%24D%3A%24D%2CMATCH(%24C3%2C'sheet%202'!%24A%3A%24A%2C0))%2C%22no%20such%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-772755%22%20slang%3D%22en-US%22%3ERe%3A%20bulk%20data%20reconciliation%20want%20to%20map%20the%20numbers%20in%20front%20of%20the%20same%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-772755%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20so%20much%20sir.%20i%20am%20highly%20obliged%20to%20you%20for%20the%20formula.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-773101%22%20slang%3D%22en-US%22%3ERe%3A%20bulk%20data%20reconciliation%20want%20to%20map%20the%20numbers%20in%20front%20of%20the%20same%20number%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-773101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F381563%22%20target%3D%22_blank%22%3E%40aayushman_mishra%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welcome%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
aayushman_mishra
Occasional 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
Highlighted
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")
Highlighted

@Sergei Baklan Thank you so much sir. i am highly obliged to you for the formula.

Highlighted
Related Conversations
History and Data
rosenbloomsnka in Microsoft To Do on
0 Replies
How often the sync is triggered?
HotCakeX in Discussions on
5 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies