+ Reply to Thread
Results 1 to 2 of 2

VLOOKUP issues

  1. #1
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    VLOOKUP issues

    on sheet 2 I have a table with columns a-o and rows 1-645. Various calculations get me to my end result in column "o"
    Using 3 cells on sheet one, a drop down containing group names, a drop down showing the groups as selected and a cell to show the result.
    The group is correct, the drop down shows the correct groups but I am getting an error when I try to show the corresponding value in column o.

    This is what I am using...any help would save my hair
    Thanks
    =VLOOKUP(AH7, Sheet2!$A$2:$O$645, 15, FALSE)*C7
    Last edited by mojobaabby; 09-24-2010 at 08:29 AM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: VLOOKUP issues

    what error do you get?

    #N/A means the value can not be found. Check that the lookup values are exactly the same. Leading/trailing spaces (or other invisible characters) is often an issue.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1