=VLOOKUP("test",A1:H100,3,0)

looks up test in A and returns what's in column C in the same row if found
(3)
1 is the first column in the lookup table

Regards,

Peo Sjoblom

"sarah" wrote in message
...
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.