While working on Excel reports I need to pull data from another worksheet using HLOOKUP. How can HLOOKUP be used correctly in Excel when the lookup value and data are located across two different sheets?

You can absolutely use HLOOKUP across different sheets, and it’s actually pretty straightforward once you get the syntax right. The key thing is that your lookup row must be the first row of the table you’re referencing.

Here’s a simple example:

=HLOOKUP(A1, Sheet2!A1:D5, 3, FALSE)

What’s happening here: - A1 → lookup value from your current sheet
- Sheet2!A1:D5 → table range on another worksheet
- 3 → row number to return data from
- FALSE → exact match (recommended for reports)

Just make sure the column headers in Sheet2 are consistent. Microsoft’s official docs explain this well if you want more examples:
https://support.microsoft.com/en-us/excel