2 way lookup
Lookup multiple values from a list where vlookup will not work
Lookup unique values from a list where vlookup will not work