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?
Bookmarks