Use a combination of the INDEX & MATCH functions. Its tricky at first
but worth learning.

Or you can just cheat and output the data in some hidden column and
link to that data.

~ Victor Lai