trace precedents
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 » Trace Precedents

Trace Precedents

resolvedResolved · Low Priority · Version 2007

replyReply Fri 16 Dec 2011, 16:50Delegate Vicky said...

Vicky has attended:
Excel Intermediate course

Trace Precedents

Do Trace Precedents work with Vlookups?

For upcoming training course dates see: Pricing & availability

replyReply Wed 21 Dec 2011, 09:40Trainer Anthony said...

RE: Trace Precedents

Hi Vicky, thanks for your query. Trace precedents on a VLOOKUP tells you where the table array and the lookup value is coming from.

Hope this helps,

Anthony

 

Please browse our web site to find out more about
microsoft excel courses in london and other Microsoft training courses.

Excel tip:

Repeat action

The F4 key will usually repeat your last action. e.g. delete a row, then select another row and press F4 to delete again.

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