How to apply Vlookup on duplicate values

Ever came across a situation where you need to apply Vlookup on duplicate lookup values?? Like the one below…     Note:- Download the Exercise workbook from here. Here we have course ID repeating in “Lookup Table”. If we simply apply Vlookup in result table, where course ID “A1005” is appearing multiple times, it will …

How to apply Vlookup on duplicate values Read More »