Consider the previous example only but show the sales manager efficiency level in the next line. Sometimes our data would need to be separated by a line break instead of spaces or characters, as shown in the previous examples. The formula cell A1 adds the value of cell B1 to get the result as Ramya. Instead of using concatenate function, we can use an ampersand (&) as its concatenation operator, and we can use it instead of the concatenation function with the same functionality and in a much simpler way. We need to use CONCATENATE and Vlookup to get the accurate sentence here.įirstly Concatenate function taking the sales manager as a reference and adding the word Sales is then, fetching the sales data of the sales manager by Vlookup and adding the value of and his then again fetching the remarks column value by using Vlookup. For example, Andrews Sales is 9724, and his Efficiency is 78.56%. Now, we need to concatenate the Vlookup value with their efficiency level. In the third table, we have their names sorted from A to Z, and this table contains their efficiency level. Therefore, we need to extract the sales value from Table 1 using Vlookup. In this table the sales value is missing. In the second table, we have their names sorted from A to Z. The first table has their name, how many units they sold, the price per unit, and the total sales value. If we pass without a double quote, we get an error. Whenever we pass an argument other than cell reference, we need to include that within the double-quotes. We need to place space with double quotes on either side of the space after the first argument to get an accurate result.
0 kommentar(er)
