i would like to lookup a cell on a worksheet and if the
value in the cell is equal to a specific reference value
such as "test" that it will return the contents of another
cell in the same row.