Spreadsheets - Category Questions

• 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?