Hlookup Funtion
Syntax HLOOKUP(Criteria, Range, Row, Type) Criteria (required) – This is the value you are going to try to find.Range (required) – This is the range of cells that you want to search.Row (required) – This is the row number of the range that contains the result you want to return.Type (optional) – This is the type of match you are looking for. FALSE if you want an exact match and TRUE if you want an approximate match....