course excel training vba london - v look up

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » course excel training vba london - V look up

course excel training vba london - V look up

resolvedResolved · Low Priority · Version Standard

Matthew has attended:
Excel Intermediate course
Excel Intermediate course

V look up

How do I assign names to data in a huge data list?

RE: V look up

Hi Matthew

Thank you for your question, and apologies for the delay in reply.

You can assign names to cell ranges by doing the following:

1. Select the cell range you wish to name
2. Click in the Name box (near the top of your screen, under the box where you choose the font type).
3. Enter a name for the range, without using spaces as part of the range name
4. Press Enter to assign the name to the cell range.

To edit the cell range that the name refers to:
1. Go to Insert/Name/Define
2. Select the name of the range from the large box.
3. Use the Refers to: box at the bottom of the dialogue box to reselect the cell range.
4. Click OK.

You can also add and delete named ranges from within the same dialogue box.

I hope this helps.
Amanda


 

Excel tip:

Adding a comment to a formula

1. At the end of the formula, add a + (plus) sign.
2. Type the letter N, and in parentheses, type your comment in quotation marks.

eg.

=CurrentAssets / CurrentLiabilities+ N("The formula returns Current Ratio")

View all Excel hints and tips


Server loaded in 0.08 secs.