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

microsoft excel training - vlookup

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - VLOOKUP

microsoft excel training - VLOOKUP

ResolvedVersion Standard

Kara has attended:
Excel Intermediate course
Excel Advanced course

VLOOKUP

Will Vlookup work when searching for a value within a worksheet where the values are formulas? (eg SUMIF)

RE: VLOOKUP

Yes, it will

Excel tip:

Status Bar Functions

When using the SUM, MIN, MAX, AVERAGE and COUNT functions, the result of such calculations are displayed in the worksheet.

However, if a range of cells, containing numbers, is highlighted, and then a right-mouse click is performed at the bottom right side of the status bar, then the result of those functions will be displayed.

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.09 secs.