The vlookup function is traditionally used to search for a value in the
leftmost column of a table, and then returns a value in the same row from a
column you specify in the table.

However is it possible to tell vlookup to ignore the first value in a
column and use the second version and then return the value in the same row
in the next column.

I am interesting in using this as I have multiple versions of the same value
in a column

Thanks