+ Reply to Thread
Results 1 to 2 of 2

VLookUp Question

  1. #1
    carl
    Guest

    VLookUp Question

    I have the vlookup formula below in b2. My table names are in row1 (Jan,Feb).
    Is it possible to have the lookup formula refer to cell b1 for the name of
    the table.

    Jan Feb
    QQQQ =VLOOKUP(A2;B1;4;FALSE)

    Thank you in advance.


  2. #2
    pinmaster
    Guest
    Try:
    =VLOOKUP(A2,INDIRECT(B1),4,0)

    HTH
    JG

+ 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