I am trying to use a lookup formula in excel and it was working fine until I
entered FALSE on the end, at whcih p[oint it tells me I have too many
arguments.

This is the formula:

=LOOKUP(A4,'C:\Documents and Settings\temp\My Documents\[AE prices for
spares.xls]Sheet1'!$B:$B,'C:\Documents and Settings\temp\My Documents\[AE
prices for spares.xls]Sheet1'!$D:$D, FALSE)

Is there a way around this?

Any help would be appreciated guys.

Thanks