The VLOOKUP function in Excel can be a very useful tool when you need to find specific data in a large spreadsheet. However, there are times when the data you are looking for is not in the same column as the data you have entered into the function. In these cases, you will need to adjust the VLOOKUP function so that it looks in the correct column for the data you need. Here is how to do this:
The next argument is the column index number. This tells Excel which column of our table array contains the value we are looking for. In our example, we are looking for a value in column C, which is the third column of our table array. Therefore, our column index number would be 3.
After the column index number, we need to tell Excel whether we want an exact or approximate match. An exact match means that Excel will only return a result if it finds an EXACT match for our search value. An approximate match means that Excel will return a result even if it does not find an EXACT match for our search value. In our example, we want an exact match, so we will type ,0). The "0" tells Excel that we want an exact match.
The last part of our function is the closing parenthesis. After you have typed everything else into your cell, type a closing parenthesis and press Enter.