Can you combine hlookup and vlookup

Hi Kawser, I have always enjoyed your blog posts, they are insightful and helpful. This uses the match to return the column number of the selected month and subsequently vlookup to the product name based on the column number to obtain the product name for the given month.

Thanks to your blog posts, I have developed a strong interest in writing and understanding excel formulas. We provide tips, how to guide and also provide Excel solutions to your business problems.

I earn a small commission if you buy any products using my affiliate links to Amazon. Contact Privacy Policy. Excel Formulas. Siam Hasan Khan Nov 1, Table of Contents hide. Further Readings. Click to see the full image. Save Saved Removed 0. Siam Hasan Khan.

Related Articles. Added to wishlist Removed from wishlist 0. Compound Interest Formula in Excel 4 Examples. Reply George Jun 20, at PM. Reply Kawser Jun 21, at PM. Reply vinodhini Oct 9, at PM. Reply Kawser Oct 9, at PM. Reply Marsh Dec 27, at PM. 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. Subscribe to Excelchat. 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. So you would be forgiven for wondering what the point of an approximate match is. They can be very useful…. Say that we have a price list and we need to check the value of a particular product on a particular date:.