Today, I went through Lookup and Reference functions with ExcelMaven. I covered the following areas:
Named Arrays
ROW/ROWS
COLUMN/COLUMNS
VLOOKUP and HLOOKUP
Named Arrays
This is exactly as it sounds, an array that is named. Using named arrays helps us simplify a lookup function if the array is to be used in multiple formulas. After selecting the array, you can either go to the formula tab and click on name manager to name it or edit it in the name box shown on the Excel worksheet.
ROW/ROWS
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1688764870752/5889b137-fc51-4243-859e-deae510981f3.jpeg" alt class="image--center mx-auto" />
COLUMN/COLUMNS
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1688765006585/861b3934-8421-4908-b6b5-b0a0f5cd3ddb.jpeg" alt class="image--center mx-auto" />
VLOOKUP/HLOOKUP
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1688765030366/57a8ec0f-81e2-4980-ad26-2be85bb7fcb0.jpeg" alt class="image--center mx-auto" />
<img src="https://cdn.hashnode.com/res/hashnode/image/upload/v1688765061580/8702aea6-ac3e-49cc-8b26-4369532355d3.jpeg" alt class="image--center mx-auto" />
The VLOOKUP and HLOOKUP functions were somewhat challenging, but I'm confident I have a good grasp of them.
Thank you, that'll be all for today.

Today, I went through Lookup and Reference functions with ExcelMaven. I covered the following areas:

**Named Arrays**

**ROW/ROWS**

**COLUMN/COLUMNS**

**VLOOKUP and HLOOKUP**

**Named Arrays**

This is exactly as it sounds, an array that is named. Using named arrays helps us simplify a lookup function if the array is to be used in multiple formulas. After selecting the array, you can either go to the formula tab and click on name manager to name it or edit it in the name box shown on the Excel worksheet.

**ROW/ROWS**

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1688764870752/5889b137-fc51-4243-859e-deae510981f3.jpeg align="center")

**COLUMN/COLUMNS**

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1688765006585/861b3934-8421-4908-b6b5-b0a0f5cd3ddb.jpeg align="center")

**VLOOKUP/HLOOKUP**

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1688765030366/57a8ec0f-81e2-4980-ad26-2be85bb7fcb0.jpeg align="center")

![](https://cdn.hashnode.com/res/hashnode/image/upload/v1688765061580/8702aea6-ac3e-49cc-8b26-4369532355d3.jpeg align="center")

The **VLOOKUP** and **HLOOKUP** functions were somewhat challenging, but I'm confident I have a good grasp of them.

Thank you, that'll be all for today.

Lookup Reference Functions