Hi Alan, The third part of the formula, where you've put $E:$E has to be replaced by either 1 or 2(since your table array is just D and E column).
Thanks, Shreedar On Sun, Oct 10, 2010 at 2:30 AM, Alan <jalantho...@verizon.net> wrote: > 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 > -- ---------------------------------------------------------------------------------- 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