Prev: seperate
Next: How do I use Conditinal Format for another cell?
From: Megglesface on 22 Feb 2010 11:16
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
From: RonaldoOneNil on 22 Feb 2010 11:26
Why have you added FALSE on the end ?
What are you trying to achieve by it ?
The LOOKUP function does not take this extra parameter, hence the error.
VLOOKUP & HLOOKUP take a parameter of TRUE or FLASE at the end.

"Megglesface" wrote:

> 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
 | 
Pages: 1
Prev: seperate
Next: How do I use Conditinal Format for another cell?