• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Need help on hlookup

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?
 
Perhaps you are looking for this

=HLOOKUP(B$8,$A$1:$E$4,MATCH($A9,$A$1:$A$4,0),0)
 

Attachments

  • Hlookup.xlsx
    10 KB · Views: 4
Back
Top