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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Excel Training and help » V Look Ups

V Look Ups

ResolvedVersion 2003

Tue 20 May 2008, 16:05 Delegate Victoria said...

Victoria has attended:
Excel Intermediate course

V Look Ups

Is it possible to create one Look up table saved in it's own file which could be then used in subsequent workbooks or would the look up chart need to be within a file

Wed 21 May 2008, 11:04 Trainer Stephen said...

RE: V Look Ups

Hi Victoria

Thank you for your question

There is no problem here. You can create a file containing all your lookups.

When you want to build a formula that references the lookup, all you need do is open the lookup file and reference the cells in the lookup file using the function wizard.

Be aware however that if you subsequently move the lookup file, you may break the link.It is best therefore to keep the lookup file in the same folder as the other workbooks

Regards

Stephen

Excel tip:

Rotating Text in an Excel 2010 Worksheet

Maybe you want to draw attention to certain text or you just simply want to make your worksheet look more exciting!

One of the things you might consider is, rotating the text in a particular cell or set of cells.

1) Select a cell you would like to rotate
2) Click the ''Home'' tab in the Ribbon
3) Click ''orientation'' in the ''Alignment'' section
4) A pop up menu will appear with a few choices, if you want to decide yourself how many degrees to rotate the text, then click ''Format Cell Alignment.''

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

V Look Ups

V Look Ups

RE: V Look Ups

Excel articles

Excel tip:

Rotating Text in an Excel 2010 Worksheet