HLookup

Short Description Perform searches in Excel rows or columns and extract data in any direction from the found reference. The final form of this recipe is: Searching a column and returning a value in another column =INDEX(<Column to extract value from>,MATCH(<Value of criteria used for looking>,<Column to be searched for value>,0)) Searching a row and returning a value in another row =INDEX(<Row to extract value from>,1,MATCH(<Value of criteria used for looking>,<Row to be searched for value>,0)) Ingredients Microsoft Excel The Need In many scenarios, data held in the form of a table needs to be searched for a certain criteria and when the criteria is met some pieceRead More →