microsoft excel training courses london - HLook up formulas

Hi Kamila,


The H lookup or horizontal lookup searches for a value in the top row of a table, and then returns a value in the same column from a row you specify in the table. 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.

For example if you used

=HLOOKUP("Training",A1:D4,4) goes across the first row and looks up the word Training, and it returns the value from row 4 that's in the same column. So in effect it goes across and then down.

Hope that helps

Tracy