Deal the VLOOKUP in an easy way right here Hello, my name is Leng. Today I would like to share an essential formula for office workers or decision-makers who need to measure and control numerical data. The VLOOKUP formula has the following structure: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup) Meaning of each parameter: lookup_value: The value you want to search for in the table. table_array: The data range you want to search within. col_index_num: The column number that contains the data you want to display. range_lookup: TRUE (or 1) if you want an approximate match or FALSE (or 0) if you want an exact match. Example: Simulate data in an Excel table. | Data for filling out the formula A B C 1 Product ID Product Name Price 2 101 Laptop 800 3 102 Smartphone 500 4 103 Tablet 300 5 104 Desktop 1200 6 105 Smartwatch 150 Suppose you want to find the price of "Tablet," which has a product code of 103 using the VLOOKUP formula: =VLOOKUP(103, A2:C6, 3, FALSE) loo
"How to Minimize Your Excel Workbook For Window?" Do you use an Excel office program? If yes, stick around with me. I will show you how to operate your Excel worksheet easily. Hello, I'm Michael Leng. Today I'm very glad to show how to minimize an Excel workbook to an icon. Tip Quiz What to do if your monitor screen upside down? This applies to use for the Excel version 2013, due to I have been using it. And also these methods are for Window program operation. The methods that I have discovered and used, there are 5 ways. 5 methods minimize Excel workbook. ⟴ Use shortcut keys "Ctrl" and "F9" ⟴ Use shortcut keys " ALT", "Spacebar" and "F9" ⟴ Click on the "Minimize workbook" square box. ⟴ Clicking on the "Minimize" command in the "Quick Access Toolbar" ⟴ Use shortcut keys "Window Logo" and "M" To make you more ease seein