Vlookup with columns function

You can use the VLOOKUP function in Excel to search for a specific value in a table and return a corresponding value from a specified column, even if that column is not the first one in the table. To do this, you will need to use the COLUMN function in conjunction with the VLOOKUP function. The COLUMN function returns the column number of a specified cell. For example, COLUMN(A1) would return 1, since A1 is in column 1. You can use this function in conjunction with the VLOOKUP function to specify a column other than the first one in the table. Example: =VLOOKUP(A2,B2:D5,COLUMN(C1),FALSE) In this example, the function will look for the value in A2 in the first column of the table B2:D5, and return the corresponding value from the column represented by C1. Note that when you use the COLUMN function in the VLOOKUP function, the column number you provide must be relative to the table range, not the entire worksheet.