Hlookup on another worksheet

[tglancy]

I'm trying to do an hlookup on a sheet other than the one the function is on.

This code works perfectly well if it is on the SAME sheet :-
=HLOOKUP("assets_fi",A1:H31,7,FALSE)

This is the code I try to run to access the figures on a sheet Called "column output"

=HLOOKUP('Column Output'!"assets_fi",'Column Output'!A1:BS127,'Column Output'!7:7,FALSE)

It fails horribly ! Where am I going wrong?
Many Thanks , a grateful new user.

 

[Andrew Poulsom]

Try:

=HLOOKUP("assets_fi",'Column Output'!A1:BS127,7,FALSE)