While using Microsoft Excel for data ... a value in the same column from a row you specify. The syntax for HLOOKUP is: ...

I will use VLOOKUP, because I want Excel to look up the values ... ve told Excel the row number for the INDEX function, I ...