exact match

The VLOOKUP formula is used to search for a value in the first column of a range of cells and return a value in the same row from...

The HLOOKUP formula is used to search for a value in the first row of a range of cells and return a value in the same column from...