HLOOKUP with Comments


New Member
Feb 27, 2019
Hello, I am new to the forum as a registered user.

Can you help me with a source code or something in vba? What I need is to gather data with HLOOKUP and comments from another workbook and put them altogether in another. I need this because the initial file is in the server and is being modified every hour.

I already searched in forum but all I have found was VLOOKUP with Comments dource code with vba.

thanks and have a wonderful day to ya all.

Col Delane

Active Member
Jan 14, 2014
Howdy and welcome to the Forum

VLOOKUP and HLOOKUP are like twin brother & sister - almost the same but not quite as they work in slightly different ways! :p:biggrin:
The essential difference is in the orientation of the way they look for the Lookup_value (vertical vs horizontal)

  • VLOOKUP looks for a value in a column, then returns the value on the same row in a specified offset column within the Table_array range.
  • HLOOKUP looks for a value in a row, then returns the value on the same column in a specified offset row within the Table_array range.

As such, any code you have which works for VLOOKUP should be easily adapted to suit a HLOOKUP.

Forum statistics

Latest member

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...