+ Reply to Thread
Results 1 to 3 of 3

Vlookup Reference column # too large?

  1. #1
    Registered User
    Join Date
    09-02-2010
    Location
    us
    MS-Off Ver
    Excel 2007
    Posts
    7

    Smile Vlookup Reference column # too large?

    hi everyone,

    i have a large spreadsheet, and need to use Vlookups. the function seems not working when my reference column numbers are larger than 28.
    anyone has the same problem?

    of course i could build some logic bridges or use Index(...match()) function to get around this.

    But just wonder if this problem is normal? or did i miss anything here? what are the best alternitives you recommend?

    Thank you very much.
    Last edited by weiwei; 09-14-2010 at 09:29 AM.

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Vlookup Reference column # too large?

    The only restriction on the column index is that the table array must have at least that many columns......otherwise you get #REF! error, If you get that error when column_index is > 28 then you might need to expand the table array
    Audere est facere

  3. #3
    Registered User
    Join Date
    09-02-2010
    Location
    us
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Vlookup Reference column # too large?

    Quote Originally Posted by daddylonglegs View Post
    The only restriction on the column index is that the table array must have at least that many columns......otherwise you get #REF! error, If you get that error when column_index is > 28 then you might need to expand the table array
    that's right. just tested. Thanks a lot.
    Sorry about the confusion.

+ 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