Results 1 to 2 of 2

If Vlookup referencing column title :)

Threaded View

  1. #1
    Registered User
    Join Date
    03-19-2012
    Location
    Uruguay
    MS-Off Ver
    Excel 2003
    Posts
    1

    Talking If Vlookup referencing column title :)

    Hello!

    I have data in two tabs and need to enter an if_vlookup formula in one cell, referencing the title of a column on the next tab:

    TAB1
    JAN
    Austria 4,444
    Belgium 4,022
    Denmark 1,341


    TAB2

    JAN FEB
    Austria 4,444 5,555
    Belgium 4,022 3,553
    Denmark 1,341 1,009

    I want to enter a vlook up on TAB1, where the data (4,444 on the example) will be updated depending on the title of the column. In this case it says JAN, next month when I change the title on TAB1 to FEB, I want the figure to be updated to 5.,555.
    TAB 2 has fixed data, unchangable. I need to update the data only in TAB1

    I have the impresion this is an If Vlook up, but can't find the correct way to write it...

    ANY HELP WITH THIS WILL BE VERY VERY APPRECIATED
    Last edited by AllisonD; 03-19-2012 at 03:51 PM. Reason: solved

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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