Matching a text reference in separate Excel sheets

[prssmzk]

I have been going crazy trying to write a statement that will allow me to find a text reference that is common to both spreadsheets but in different column, row numbers. Once I have found the cell I want to offset the column position by 17 and then copy the contents of that final cell back into the original spreadsheet.

What I tried was:
In spreadsheet1, at position cell R10 I typed the following ... =match("text in spreadsheet1", spreadsheet2!$E:E,0) 'this returned a number 14, saying that the text in spreadsheet1" was found in spreadsheet 2 at position cell E14.

so then I tried
=concatenate("U",R10) 'this then gave U14 as the new position of what I wanted the contents copied back into spreadsheet 1.

This is where I got stuck. How do I copy the contents of the cell U14 in spreadsheet 2 back into spreadsheet 1 at cell R10 (ie where I started from)?

Any help would be appreciated?

Cheers