Excel Masters

Here's a nice TIP for VLOOKUP function: If you wish to search for a value without an exact match, you can add "*"& from both sides of the value. For example : VLOOKUP("*"&C2&"*",D:D,1,FALSE)

Let us know if it works for you :)

11 basic Excel tricks that will change your life How many of these do you know?