redbaronnz's channel
Loading...
-
3 weeks ago
Dueling Excel - "Total All Lookups": Podcast #1513
Mike and Bill look at two methods to lookup a column of sales amounts in order to create a single cell formula that will add all the bonuses. Learn...
redbaronnz
commented:
-
2 months ago
The Faces - Maybe I'm Amazed
Really rather glorious, this. Rodlington Stewart with Ronnie Lane, Ronnie Wood, Ian McLagan and Kenney Jones tearing the arse out of Macca's 'Maybe...
redbaronnz
liked
-
2 months ago
Scotty's Revenge Hilux Commercial
redbaronnz
commented:
Lloyd's Scott's revenge did not impress MOT one bit. While they were fine with Crumpy pushing the limits on a off-road track and the scaring the living whatever out of Scotty they were concerned about dangerous driving being shown in a town setting where other people could get hurt if something ...
-
2 months ago
A History of Scotland - S02E03 - The Price of Progress - Part 3/6
BBC Scotland Documentary - Through the winning and losing of an American empire and the impact of the Scottish Enlightenment, Neil Oliver reveals h...
redbaronnz
liked
-
3 months ago
Leave John Key Alone
vital support
NOTE: *humour alert* for the uninitiated. This is a piss-take. Google "Leave Britney Alone" if you're a little confused.
redbaronnz
liked
-
3 months ago
September - Until I Die
Official video for her latest Scandinavian single release: Until I Die.
www.myspace.com/catchytunesrec
ords
redbaronnz
liked
-
9 months ago
Underworld - Underneath The Radar (1988)
Underworld Mark 1 Video
Sire Records, 1988
redbaronnz
liked
-
9 months ago
Learn Excel 2010 - "Comparative Histogram Part II": Podcast #1523
In Episode #1522, Bill showed us how to set up a Comparative Histogram Chart. Today, in Episode #1523, Bill shows us alternative ways to set up a v...
-
9 months ago
Excel Magic Trick 873: VLOOKUP ROUND Function? Lookup Value In Table Rounded To Nearest Value
Download workbook: http://people.highline.edu/...
Learn how to:
1. See how to avoid the default VLOOKUP behavior and instead fin...
About redbaronnz's channel
I've been using =Index(...match()) to lookup values to the left of the value column for the past few weeks. Lookup seems to have the same capabiily; However make sure the lookup vector and lookup result column's are "absoluted" =lookup(Z1, F$1$:F$100$, A$1$:A$100$)