After that, we selected the complete table from which we need to hlookup function and after that, we need to input the number of the row at which Net profit is located which in this case is 4.
Hlookup stands for Horizontal Lookup and can be used to retrieve information from a table by searching for matching rows of data and outputting from the appropriate columns. VLOOKUP looks for column values, but HLOOKUP looks for row values.
Finds a value in the top row of a table or array of values and returns the same column value from the specified row in the table or array. Use hlookup function when the comparison value is at the top row of the data table and you want to look down a specified number of rows.
Learn more about hlookup function at
https://brainly.com/question/14567875
#SPJ4
