FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -VLOOKUP stands for ‘Vertical Lookup’. It is a function that makes Excel search for a certain value in a column (the so called ‘table array’), in order to return a value from a different column in the same row.

Detailed explanation-2: -VLOOKUP could only search for a value in the first leftmost column of a data range. Similarly, HLOOKUP could only search for a value in the top row of the range: When the key field is to the right of the range you want to retrieve, VLOOKUP will not work.

Detailed explanation-3: -To get the whole row data of a matched value, please apply the following formula: Enter this formula: =VLOOKUP($F$2, $A$1:$D$12, COLUMN(A1), FALSE) into a blank cell where you want to get the result, for instance, H1, and then drag the formula to right ( from H2 to K2), and you will get the whole row data you want.

Detailed explanation-4: -Using INDEX and MATCH instead of VLOOKUP This means that the column containing the value you look up should always be located to the left of the column containing the return value. Now if your spreadsheet isn’t built this way, then do not use VLOOKUP. Use the combination of INDEX and MATCH functions instead.

Detailed explanation-5: -Use VLOOKUP when you need to find things in a table or a range by row. For example, look up a price of an automotive part by the part number, or find an employee name based on their employee ID.