Hey is there a way to use the HLookup function without having the data sorted?
Sure, just put False for the last Argument to specify an exact match.
Consulting Services :|: Excel VBA Training and Certification :|: What is a Microsoft MVP? :|: Set Your country/state Flag
Forum Rules