Problem with VLOOKUP
- StarMan
- Red & Blue Braces
- Posts: 449
- Joined: 13 Oct 2005, 18:33
- FS Record: Won FISO Mini league Sun Dream Team Euro 2004
- FPL:
Problem with VLOOKUP
I am currently working on an Excel course I bought on the internet lately to improve my knowledge, and one of the things I really wanted to master was VLOOKUP. No matter what video I saw on Youtube or article I read that tried to explain it, I always get a #N/A and this course I am taking is no exception, they even gave me a practice exercise and I copied the formula to the letter and yet still I get the error.
The question I have is could there be a box unchecked or something else that is preventing me from getting a value returned?.
I am working with Excel 2003 and I have the analysis toolpack, analysis VBA, conditional sum wizard and lookup wizard add-ins switched on.
I will keep plodding on for now trying to sort it but any help would be appreciated.
The question I have is could there be a box unchecked or something else that is preventing me from getting a value returned?.
I am working with Excel 2003 and I have the analysis toolpack, analysis VBA, conditional sum wizard and lookup wizard add-ins switched on.
I will keep plodding on for now trying to sort it but any help would be appreciated.
- rossn13
- Grumpy Old Man
- Posts: 3899
- Joined: 14 Aug 2009, 11:46
- Location: Shenzhen, China
- FS Record: 12th TFFE 09/10
- FPL:
Re: Problem with VLOOKUP
Try entering the code and then hit CTRL+SHIFT+ENTER instead of just ENTER.
You're welcome
You're welcome
- StarMan
- Red & Blue Braces
- Posts: 449
- Joined: 13 Oct 2005, 18:33
- FS Record: Won FISO Mini league Sun Dream Team Euro 2004
- FPL:
Re: Problem with VLOOKUP
I've just gave your suggestion a go in both 2003 and 2010 and still #N/A thanks for the quick reply though.
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
Re: Problem with VLOOKUP
Does it give the error on every VLOOKUP formula?
It might be that the values you are looking up are different. ie one is text and the other is a number (as in a number is formatted as text).
Can you post a screenshot or something or give details as to what the exact formula is?
It might be that the values you are looking up are different. ie one is text and the other is a number (as in a number is formatted as text).
Can you post a screenshot or something or give details as to what the exact formula is?
- rossn13
- Grumpy Old Man
- Posts: 3899
- Joined: 14 Aug 2009, 11:46
- Location: Shenzhen, China
- FS Record: 12th TFFE 09/10
- FPL:
Re: Problem with VLOOKUP
Not sure then sorryStarMan wrote:I've just gave your suggestion a go in both 2003 and 2010 and still #N/A thanks for the quick reply though.
Are you able to upload the file?
- StarMan
- Red & Blue Braces
- Posts: 449
- Joined: 13 Oct 2005, 18:33
- FS Record: Won FISO Mini league Sun Dream Team Euro 2004
- FPL:
Re: Problem with VLOOKUP
I've sorted it, but I will post the image anyway I haven't put Facebook.com in D2 I've only typed Facebook so it won't match.
You do not have the required permissions to view the files attached to this post.
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
Re: Problem with VLOOKUP
One of the problems with Excel is that its error messages are pretty useless.
Glad you sorted it.
Glad you sorted it.
- WilBert
- Dumbledore
- Posts: 7767
- Joined: 28 Dec 2009, 21:07
- Location: 2nd in SP4's Ashes comp.
Re: Problem with VLOOKUP
A common mistake is that your left hand column that you're doing a lookup on has to be in some type of order e.g alphabetically.
- StarMan
- Red & Blue Braces
- Posts: 449
- Joined: 13 Oct 2005, 18:33
- FS Record: Won FISO Mini league Sun Dream Team Euro 2004
- FPL:
Re: Problem with VLOOKUP
Thanks for the help guys I've got the hang of it now, and some of the errors I am getting are my own doing. I'm assuming Excel can do certain things and it won't and it'll just give me an error message instead. I just tried to do a VLOOKUP of my own and got the error again, realised what I had done, and corrected it and it worked so I am learning.
- stevejtr
- Grumpy Old Cereal Killer
- Posts: 4537
- Joined: 13 Oct 2005, 18:32
- Location: Out and about
- FS Record: I always liked the old Tele FA Cup competition...
Re: Problem with VLOOKUP
once you've mastered that then there's HLOOKUP... working on columns instead of rows
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
Re: Problem with VLOOKUP
WilBert wrote:A common mistake is that your left hand column that you're doing a lookup on has to be in some type of order e.g alphabetically.
Not sure that's the case anymore. I have done countless VLOOKUP where there has been no logical order and they work fine.
- stevejtr
- Grumpy Old Cereal Killer
- Posts: 4537
- Joined: 13 Oct 2005, 18:32
- Location: Out and about
- FS Record: I always liked the old Tele FA Cup competition...
Re: Problem with VLOOKUP
I think in excel 2003 this was the case. doesn't seem to be now
- WilBert
- Dumbledore
- Posts: 7767
- Joined: 28 Dec 2009, 21:07
- Location: 2nd in SP4's Ashes comp.
Re: Problem with VLOOKUP
I really must come into the 21st century with my computer programmes.
- Surprised
- FISO Jedi Knight
- Posts: 26528
- Joined: 13 Oct 2005, 18:32
- Location: Home
- FS Record: TFFOSM MotW in 2008 and MotM in 2003. 78th overall in TFFO for 2002/3 and 2003/4
- FPL:
Re: Problem with VLOOKUP
WilBert wrote:I really must come into the 21st century with my computer programmes.
Still with Visicalc?
http://vlookupweek.wordpress.com/tag/sp ... t-history/" onclick="window.open(this.href);return false;
- Mystery
- FISO Knight
- Posts: 13816
- Joined: 13 Oct 2005, 18:33
- Location: Just about here
- FS Record: 116th in TFF 05/06
- FPL:
- Contact:
Re: Problem with VLOOKUP
No it doesn't if the 4th attribute of the formula is zero. Which it really should be in 99% of cases.WilBert wrote:A common mistake is that your left hand column that you're doing a lookup on has to be in some type of order e.g alphabetically.
View Latest: 1 Day View Your posts