I am using Excel 2007 and having a strange problem with the VLOOKUP
function. I have never used it before, but I have looked at examples
on the Internet. However, I cannot figure it out.
I placed the following formula in Cell B2:
=VLOOKUP($A2,$D$2:$E$9,$E:$E,FALSE)
and then copied it to B3 and B4, which respectively show up as:
=VLOOKUP($A3,$D$2:$E$9,$E:$E,FALSE)
=VLOOKUP($A4,$D$2:$E$9,$E:$E,FALSE)
My lookup table is located at D2:E9, with what I am looking up in
column D, and the value for the lookup in column E.
I placed the second entry in the table in cells A2, A3, and A4.
The VLOOKUP functions in cells B2, B3, and B4 show the following
results:
B2: #VALUE!
B3: <second entry in the table>, same as in A3
B4: the correct lookup value.
This does not make any sense to me, based on the examples I have
seen.
What am I doing wrong? Thanks, Alan
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
