problem with offset function

[matpj]

Hi guys and girls,

I am trying to use an OFFSET function to lookup a value in one column, find its match on another sheet, and then return the value that is 5 columns to the right of that match.

my formula:

=OFFSET('Project Schedule ETC'!A1,MATCH('Holding Cell'!T6,'Project Schedule ETC'!A:A,0),5, 1, 1)

I am putting this formula in U6 on the 'Holding Cell' worksheet
Column A in the sheet 'Project Schedule ETC' has a list of project numbers that should contain a match to the value in T6
The formula just returns 0 no matter what I change the '5' to..

can anybody suggest what is wrong with this..

thanks in advance,
Matt