Combine VLOOKUP and MATCH and see the magic. Download exercise file from my Facebook Page: www.facebook.com/LearnWithSyedTahaGhayas