Vlookup Range Lookup. For approximate match set range lookup to true or 1. For vlookup this first argument is the value that you want to find.
The second argument is the range of cells c2 e7 in which to search for the value you want to find. This name is not intuitive so you ll just have to memorize how it works. Vlookup b7 table1 2 true when the sales amount is 12 345 vlookup returns the expected bonus amount of 500 as shown below.
Define the categories you want to assign your data set values to.
The second argument is the range of cells c2 e7 in which to search for the value you want to find. For exact match use false or 0. By excel off the grid the 2nd argument in the vlookup function is the table array. Before we get into applying the formula to our example let s have a quick reminder of the vlookup syntax.
