Now well add our arguments. This will help you insert a column to the left of the Company column. Name it as Company Product.
This can be an actual value or a blank cell that will.
On creating the helper column enter the formula C2-D2. Set the fourth argument of the VLOOKUP function to TRUE to return an approximate match. You set up a VLOOKUP formula as follows. VLOOKUP lookup value table array column index range lookup Lookup value is the value you wish to look up.