Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

h formula

ResolvedVersion 2007

Zoe has attended:
Excel Intermediate course

H Formula

What is a H look-up formula?

RE: H Formula

Hi Zoe,

Thank you for your question.

Hlookup formulas are used to retrieve data arranged in rows by returning a value based on the row you select.

I hope this answers your question.

Regards

Simon

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time




View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.