• 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.

Hlookup does not work correctly

Dear all,

I have the following Excel.

In Sheet1C2 I try to perform a hlookup function to fetch data from the source-data tab. But for some reason this is not working. ANy thoughts on what goes wrong?
 

Attachments

  • example.xlsx
    11.4 KB · Views: 5

marcvanderpeet12

=HLOOKUP(B2,'source-data'!$G$2:$J$1000,4,FALSE)
Your ANy thoughts on what goes wrong?
Have You compared You use with - how it works?
Description
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.
Syntax
HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])
# Is there TV De Oorsprong in the top of row?
# is there .. something in 4th row?
 
i got it to work except for approximate match
=HLOOKUP(B2,'source-data'!$G$2:$J$1000,1,0)
 

Attachments

  • example.xlsx
    11.2 KB · Views: 0
Back
Top