Excel: Combining HLOOKUP and VLOOKUP HD

26.12.2013
This video tutorial combines HLOOKUP and VLOOKUP which is great if you have a matrix and want to be able to select a particular column or row. Here I use a table with delivery charges to various cities so you can select where it is going from and where it is going to. Gary Schwartz from http://www.jargonfreehelp.com shows us how. You may need to familiarise yourself with VLOOKUP and HLOOKUP first. Here are tutorials to help with that: VLOOKLUP: http://youtu.be/oeQ_It-v3to HLOOKUP: http://youtu.be/WfzkemYmzfg

Похожие видео

Показать еще