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?
=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?