Hlook up and Vlookup

Hi Aga,

I hope you are fine.

Thank you for the forum question.

The Vlookup is for vertical lists and the Hlookup for horizontal lists.

All the lists we worked with today were vertical and most lists are vertical.

In vertical lists you have a header row and the records organised down. One record in each row.

In horizontal lists you have the headings in the first column and you have a record in each column across.

The only difference between the Vlookup and Hlookup is that the Vlookup need the Column index number (from which column from the table array want we to get the data from) and Hlookup the Row index number (from which row in the table array want we to get the data from).

=Vlookup(Lookup value, Table array, column index number, range lookup)

=Hlookup(Lookup value, Table array, Row index number, range lookup)

If you select C5 on the worksheet Hlookup in the course Excel file and type the function:

=HLOOKUP(A5,$A$8:$P$13,6,0)

And the type 11158 in A5. Then the function will return the postcode for the first client (row 6 in the table array).

I hope all this makes sense.



Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector