Learn Excel Episode 884: HLOOKUP with VLOOKUP?

Posted in Companies, Podcasts on November 07, 2008

Robert asks how he can combine an HLOOKUP and a VLOOKUP together into a single formula. This is a common problem, but you don't use either VLOOKUP or HLOOKUP. Instead, Episode 884 will introduce a function called MATCH. This obscure but versatile function is similar to both VLOOKUP and HLOOKUP. Episode 884 shows you how to solve this problem.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, MATCH, formula