excel consultants - vlookups
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel consultants - VLOOKUPS

excel consultants - VLOOKUPS

resolvedResolved · Low Priority · Version Standard

replyReply Wed 5 Sep 2007, 13:46Delegate Addy said...

Addy has attended:
Excel Advanced course
Excel Intermediate course

VLOOKUPS

I did a VLookup on Excel, the formula is showing the correct result, but on the sheet itself all I am getting is the formula showing.

For upcoming training course dates see: Pricing & availability

replyReply Mon 10 Sep 2007, 12:06Delegate Andy said...

RE: VLOOKUPS

If u use pc keyboard try to press CTRL +

 

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


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard