XPATH - Selection TD next to the selected xpath table which contains SPAN : I have searched through the forums for an answer but nothing found looks at exactly what I need to do.

At the moment I'm using the following XPath to locate a value in a table

    //table[1]/tbody/tr/td[15]/span

This searches each row for a span value in td[15] as only 1 span value exists.

Now I have that value and know the row I would like to get the value in td[6] in that row

    //table[1]/tbody/tr[the row where span is]/td[6]/a[1]

simply put the perfect example would be:

    //table[1]/tbody/tr[//table[1]/tbody/tr/td[15]/span]/td[6]/a[1]

any help would be great.