Hello:
I'm having an issue with excel 2007. All the formulas I try using, whether it is through the wizard or manually entered, I consistantly get an error message saying "you have entered too few arguements for this function."
Do you have any insight on why this is happening?
Does every formula do this? Try entering this in cell C1 of a new workbook:
Please Login or Register to view this content.
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
show us some examples that give this error
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Oh Thank YOU!!
Here's an example:
In the attached file, if you go into cell E14 the formula for a vlookup appears and all looks good but if you go into the formula box and press enter that is when you get the error message. Also, if I try to enter the same formula using the wizard it gives me the same error.
It does not do it on less complicated fuctions (i.e. SUM) only on vlookup and index (but that's as far as I've gotten in the book.)
I've attached the excel file and a word doc showing what I'm talking about.
Thanks again for all your help!!
cant get that to fail,but i do notice in excel options you have enable iterations checked, that is normally unchecked
I'm guessing that means there is something wrong with my excel or computer then....
Thanks for your help.
Looking at your screenshots, you're missing commas between the arguments.
You have:
=VLOOKUP(D14 Lookup 2)
It should be
=VLOOKUP(D14, Lookup, 2)
Incidentally, using "Lookup" as a named range isn't the best because LOOKUP is also an Excel worksheet function. I'd call the named range something else.
Thanks Collin. I tried adding the commas but it then gives me an error message that says that I had an error in nope. Just another error....now it says the "formula you typed contains an error." Even when I try to use the wizard....it's bizarre.
it seems like my excel doesn't recognize commas for some reason...the file originally had commas and when I open it, there are no commas and when I again enter them...I still get the error message.
what is your setting for list seperator in control panel/regional settings
and fwiw i agree with colin named range same as function not a good idea
Last edited by martindwilson; 04-28-2011 at 05:12 AM.
YOU Mr.Wilson...ROCK!!!!!!!!! I changed it to a comma and it works! THANK YOU, THANK YOU, THANK YOU, THANK YOU!! I really thought I was going to have to get a whole new excel.
Thank you all!!!!
P.S. Note take on the name range
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks