Combining VLOOKUP and HLOOKUP Functions

HLOOKUP and VLOOKUP functions are very useful functions on their own but if you combine them together you can do even more. If you are using VLOOKUP rather than having the two columns one with the value to lookup and the other with the value to retrieve with the HLOOKUP you could get it to get values from more than one column.

In the example in the video below you can see how I used this to determine delivery charges from one to city to another using a table of charges based on the cities. The HLOOKUP determined which column the delivery was coming from and the VLOOKUP uses the row where it is going to. The HLOOKUP has the column number which the VLOOKUP uses for determining the column index number.

If you need to know about the VLOOKUP and HLOOKUP function you can see these on my website www.jargonfreehelp.com at the following links:

About garysch

A bit of a techno nut who likes sharing what I know about technology, especially with those who struggle with it. Also through my podcast www.jargonfreehelp.com
This entry was posted in Excel, Office 2010 and tagged , , , , . Bookmark the permalink.

2 Responses to Combining VLOOKUP and HLOOKUP Functions

  1. panduari D says:

    In the example in the video below you can see how I used this to determine delivery charges from one to city to another using a table of charges based on the cities. The HLOOKUP determined which column the delivery was coming from and the VLOOKUP uses the row where it is going to. The HLOOKUP has the column number which the VLOOKUP uses for determining the column index number.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s