|
|
too many arguments error message in excel
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
|
|
0
|
|
|
|
Reply
|
 Utf
|
2/22/2010 4:16:01 PM |
|
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
|
|
|
0
|
|
|
|
Reply
|
Utf
|
2/22/2010 4:26:01 PM
|
|
|
1 Replies
686 Views
(page loaded in 6.091 seconds)
Similiar Articles: too many arguments error message in excel - microsoft.public.excel ...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. Error message: "Too many cell formats" - microsoft ...too many arguments error message in excel - microsoft.public.excel ... Error message: "Too many cell formats" - microsoft ... For example, if you type a date in a cell ... How to treat this excel error: 0xc0000005 - microsoft.public.excel ...0xc0000005 error in ms access - microsoft.public.access ... Office; MS Excel; Too many arguments error ... MS ... message that ... How to treat this excel error: 0xc0000005 ... ... Error: Programmatic Access is not trusted - microsoft.public.word ...... Arguments.Count > 1 then MsgBox "Too many arguments ... XL2002: Error Message: Run-Time Error '1004 ... Excel - Excel 2007: Error 1004 Programmatic Access Is Not ... File in Use problem - again - microsoft.public.word.vba.general ...... Arguments.Count > 0 Then MsgBox "Too many arguments ... > > I suspect this problem stems from a message I got ... Weird "File in Use" error opening Excel 2007 Files on the ... Solution: Error 2306: There are too many rows to output (Access to ...Access 2000 and Excel 2000, we get > the error message "Too many ... Solution: Error 2306: There are too many rows to output (Access ... OutputTo ... which only allows ... 'Too many fields defined' error?? - microsoft.public ...After I place the code > onto someone elses computer, also running Access 2000 and Excel 2000, we get > the error message "Too many fields defined" . File in Use problem - microsoft.public.word.vba.general ...... Arguments.Count > 0 Then MsgBox "Too many arguments ... When I execute this code, I get a message dialog ... Weird "File in Use" error opening Excel 2007 Files on the ... Error 3061 - too few parameters - microsoft.public.access ...I have read many responses for the error code 3061 but to no avail. Below is the code, and when run get the error message 3061 - too few ... Pulling data into Excel "Too ... error msg on opening excel workbook - microsoft.public.excel.misc ...Use the Workbook Open event to display a message for a specific excel workbook; Set ... file, I always get an error message saying "Excel found ... Excel Error “Too many arguments for this function”? - Yahoo ...Hi I’m Maya. I am trying to define real number here, but I keep getting this message… I tried one thing; did $E$4^2+4*$E$5 on another cell. EXCEL QUESTION, PLEASE HELP!? - Yahoo! AnswersI received this error message "YOU'VE ENTERED TOO MANY ARGUMENTS FOR THIS FUNCTION ... window that will show you just what Excel sees. For too many arguments ... too many arguments error message in excel - microsoft.public.excel ...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. Excel - Youve Entered Too Many Arguments For This Function - I am ...Youve Entered Too Many Arguments For This Function - I am not an excel expert and could ... cell B42, but I'm getting the error message: "You have entered too many arguments ... Excel - Getting Error: Youve Entered Too Many Arguments For This ...Getting Error: Youve Entered Too Many Arguments For This Formula - Hello All I trying to ... - This macro will display a message box in excel when a cell reaches a ... 7/25/2012 9:10:37 PM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
32 followers. 