I like that. I never would have thought of using OFFSET & MATCH. I use VLOOKUP all the time, so it's usually my go to formula for stuff like this. Anyway, here's a link to a video that uses Ohlalayeah's scenarios with the VLOOKUP.
http://www.youtube.com/watch?v=0kYzmBncec4