Arup Dutta Chowdhury Syntax
HLOOKUP(lookup_value,table_array,row_index_num,range_lookup)
Searches for a value in the top row of a table or an array of values, and then returns a value in the same column from a row you specify in the table or array. Use HLOOKUP when your comparison values are located in a row across the top of a table of data, and you want to look down a specified number of rows. Use VLOOKUP when your comparison values are located in a column to the left of the data you want to find.
What would be You needed results?
Is there more data?