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

vlookup

ResolvedVersion Standard

Adrian has attended:
Excel Advanced course

VLOOKUP

Is it more advisable to use v-lookup rather than h-lookup or they equally as usefull

RE: VLOOKUP

v-lookup is a vertical lookup used to find values in a column, h-lookup is a horizontal lookup used to find values in a table/row.

Excel tip:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

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.