Can you use hlookup and vlookup together

The range is as below. Here is the result. It has the field labels in the first row as it is and the second row contains the column numbers. The function Column returns these numbers. Here is an easier solution to the above using Vlookup and Match. Actually, this tutorial is about the combined use of Vlookup and Hlookup in Google Sheets. Still, I am introducing you to this new combo as this is easy to understand and use.

The match function searches across the first row for the key in J3 and returns the relative position of the key. If your column labels are the month names as above, there is a shorter solution using the Date function. Here is that formula. Here the Index number is replaced by the Month function. How this Month function returns the column index?

Actually, it returns the month number from month name. I have two rows that I need to pull different values from hence multiple conditions with an hlookup , but I also want to Vlookup for a specific date. Quick Excel Help.

Get instant live expert help with Excel or Google Sheets. Post your problem and you'll get expert help in seconds Your message must be at least 40 characters. Our professional experts are available now. Your privacy is guaranteed. Connect to an Expert. The approximate match is set as 1 and exact match is set as 2. Instant Connection to an Expert through our Excelchat Service Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function.

This comment form is under antispam protection. Even this simple example shows one of the issues of the lookup functions: they only return the first match. If we need to return multiple results from a table then the lookup functions are unlikely to work.

You would either need to filter the table or use a PivotTable. The use of the optional, fourth argument. All we have changed in our formula is to omit the fourth argument. Although there are several exact matches for our value in our table, the function now returns a completely different album title.

It is actually a much more specific type of match than that:. If there is no exact match, it will find the first item in our table larger than the lookup value and match with the cell immediately above.

Here, we have re-sorted our table and used two approximate matches, and two exact matches, all referring to columns 1 and 2.