Problem with Vlookup

[MarkAndrews]

I am using this

=VLOOKUP(A3,'[Marlice Jan 06 figures.xls]Sheet1'!$A:$A,6,FALSE)

Yet, it wont return a value from 'Marlice Jan 06 figures.xls'

Any idea's?

 

[onlyadrafter]

Hello,

maybe your $A:$A needs to be $A:$F

 

[MarkAndrews]

How stupid do i feel!!! I never noticed that

Thanks mate