How to perform HLookup in excel range

Help Studio
, ,
1

This is mostly required to read the correct columns inside big sheets (where reading the whole sheet consumes a lot of time & memory), where columns may be added/removed during time.
In such cases, Hlookup can be used to first find what are the columns of the headers of interest.

1 Like
2

Hi @Udiar,

  • Start by reading the Excel sheet.
  • Loop through each row in the data:
    • Check if the current row matches the value you’re looking for.
    • If you find a match:
      • Look across that row to find the specific value you want.
      • Kind of condition can be used and use your column or incrementing counter [Row(counter).ToString().Equals(lookupValue)]
      • If you find it, you’re done.
  • If you finish looping through all the rows without finding the value:
    • Show an error message or take some other action to handle the situation.
3

@Udiar

You can use Find/Replace in Excel and then use read range accordingly to get only the column you need

cheers

4

Thank you!
In other words, there is no Hlookup function/activity, thought there is a Vlookup activity.