lookup & offset in same function with multiple files

I need to lookup a cell from File A in the first row of a tab in file B, then reference cells 6 rows below and 47 columns over from the "looked up" cell in file B. I need the offset value to appear in the function cell.

So...Look up the value "x" from file A in the first column of file B, then go down 6 rows and over 47 columns and retrieve the value in that cell.

Can this be done?