+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Vertical lookup or not?

Hybrid View

Can21 Vertical lookup or not? 06-21-2012, 05:41 AM
san2525 Re: Vertical lookup or not? 06-21-2012, 05:49 AM
  1. #1
    Registered User
    Join Date
    06-21-2012
    Location
    Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    1

    Vertical lookup or not?

    Okay, I've got this sheet that I made, with macros and everything. I'm quite an advanced programmer, but I just can't figure this out.

    I got a table, with places where advertise our company, the macro shows an userform with buttons that add 1 to the table, on the respective place.
    Heres the layout for the table:


    Almeloos Weekblad | 9 | | 0 | 2 | 3 | 4 |
    Salland Krant | 0 | | 0 | 0 | 0 | 0 |

    And much more like that, with corresponding headers above them.
    Total - [empty] - January - Febrauri - etc.
    My table is obviously much bigger, but I can't disclose it.

    Now in another sheet in the same workfolder, I want to search for the max value in a month, and display the corresponding label for the place on the other sheet. Now I've tried it with vertical look up, but I just can't seem to get it right. First I made it to search for a value in the right column.

    So I had =VLOOKUP(2; C2:C26, 1)
    but it gave me an output of 0? Shouldn't give me a 2?

  2. #2
    Registered User
    Join Date
    06-20-2012
    Location
    India
    MS-Off Ver
    Excel 2013
    Posts
    34

    Re: Vertical lookup or not?

    try Hlookup
    SANDEEP
    << press the star * if u like

+ 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