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

trace precedents

ResolvedVersion 2007

Vicky has attended:
Excel Intermediate course
Excel Advanced course

Trace Precedents

Do Trace Precedents work with Vlookups?

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

Excel tip:

Applying and removing border from cell in Excel 2010

Did you know the shortcut key for applying and removing the outline border for a cell?

CTRL+SHIFT+& Applies the outline border to the selected cells.
CTRL+SHIFT_ Removes the outline border from the selected 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.09 secs.