Excel

Hello Nidaa

Thank you for your question and welcome to the forum.

The VLOOKUP function is used when your data is arranged down columns, i.e. you have headings running across a row, with related data stored down the columns underneath.

The HLOOKUP function is used with your data is arranged across rows, i.e. you have headings running down a column, with related data stored across the rows beside the headings.

I hope this helps.
Amanda